Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlikcommunity. I need exclude a field.
I am trying set analisis.
EJ.
I have:
Colors |
Red |
Red |
Red |
Red |
Blue |
Blue |
Blue |
Black |
Black |
I need:
Colors |
Red |
Red |
Red |
Red |
Black |
Black |
My expression is:
COUNT
(~Colors = {'Blue'} >}Cant)
But this does not work
Can they help me?
Thank!!!
Hi,
Check with -= Which is used for excluding the give values.
Count({<Colors-={'Blue'}>} Colors)
Celambarasan
Hi,
Check with -= Which is used for excluding the give values.
Count({<Colors-={'Blue'}>} Colors)
Celambarasan
Great, this works.
Thank you very much!.
Ivan.
Hi ,
u can also try like this
Count({<Colors=Colors-{'Blue'}>}Colors)
Thanks,
Shiva