Set analysis for operator <>

[Fred12]

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

[Joseph_Musekura]

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

[Digvijay_Singh]

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])

[Joseph_Musekura]

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,

[Joseph_Musekura]

@Digvijay_Singh,  
As you did add new comments since 21 March, I will presume that this was solved and will close this case.
Regards,

[Digvijay_Singh]

Hi @Joseph_Musekura 

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?