my aim is just to have a set analysis in qlik sense; I did this :
Sum({<[EstUnTotal_fg?] = {'NON'}, Direction <> {TOTAL}>}[CA par année])
My aim is to have row where
EstUnTotal_fg ="NON" and Direction <> TOTAL for the CA par année
But the sign <>
doesn't work. If I replace it per the sign =
so it works.
How can I use the sign <>
in my set analysis for my CA par année
Thanks for reading me
To my knowledge, instead of using
<>
you can use= -
. It is explained in this post by Henric_CronströM. So, your set analysis would look like this:I hope it helped :)