Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello !
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
Hi @Fred12,
To exclude a value in set Analysis you need to use -=
Check this https://community.qlik.com/t5/Qlik-Design-Blog/Excluding-values-in-Set-Analysis/ba-p/1471704
Qlik Support
May be like this, replace yourkeyfield with your table keyfield, I assume both Direction and TOTAL are in the same table -
Sum({<[EstUnTotal_fg?] = {'NON'}, Yourkeyfield = {"=(Direction <> TOTAL)"}>}[CA par année])
If TOTAL is one of the value of a Direction field then
Sum({<[EstUnTotal_fg?] = {'NON'}, Direction -= {'TOTAL'}>}[CA par année])
Hi @Digvijay_Singh,
Yes, something similar.
If you still have issue when using Sum({<[EstUnTotal_fg?] = {'NON'}, Direction -= {'TOTAL'}>}[CA par année]), please share with us a small qvf with dummy data + a screenshot showing what you expect as result.
Otherwise, please confirm if the provided solution worked.
/regards,
@Digvijay_Singh,
As you did add new comments since 21 March, I will presume that this was solved and will close this case.
Regards,
The author of the post has not responded so not sure whats the next step.
@Fred12 Did you get what is needed to resolve this issue?