Using Not Equal condition in Set Analysis

[tmumaw]

Happy New Year everyone.  I'm have a small issue when using not equal condition in set analysis.  Here is the statement I am using and it's returning everything greater than 14 and I only want everything that is not equal to a 14.  Thanks.

Thom

Sum({<FISYR=,FISPD=,WKNO=,WEDAT=,[Cancel Reason] = {"<>14"}>}[Subtotal1A] * -1) 

[Miguel_Angel_Baeyens · Accepted solution]

Hi Thomas,

Your expression seems to be fine. Anyway, you could try with something like

Sum({< FISYR=, FISPD=, WKNO=, WEDAT=, [Cancel Reason] -= {14} >} [Subtotal1A] * -1)

Using the -= operator to exclude that value for that field. You could also use E() function to exclude from [Cancel Reason] all values where [Cancel Reason] equals to 14, but the former is much simpler.

Hope that helps.

Miguel

[tmumaw]

Thank you very much.  It was exactly what I was looking for.

Thom

[Anonymous]

Hello!  maybe you could help on my case. ( I'm a newbie in Qlikview) ... I have this pivotable that I want to excude an item during subtotal without suppressing null value...

Source    DEC   Jan   Feb

A              0         0       20  

B              15        20    30

C             40       50     60

I only want to add the  values from DEC to Feb in Source B and C....But I want to keep the Source A data without suppresing value ...Thus would look like this

Source    DEC   Jan   Feb

A              0         0       20  

B              15        20    30

C             40       50     60

Total           55     70         90    exclude the value in A but data would still be visible

Pls. help...

[#5]

Hi Miguel,

I tried the same way in my expression but still not working.

My expression is :

Count({<citizenship_StdPersonalInfo -= {'Singapore'}> +<isPR_StdPersonalInfo={0}>}DISTINCT(stdApplicationNo))

Can you suggest on it?

Thanks!!

-Yojas

[tmumaw]

Yojas,

Try this

Count({<citizenship_StdPersonalInfo -= {'Singapore'} + isPR_StdPersonalInfo={0}>}DISTINCT(stdApplicationNo))

Thom

[#7]

Thanks for Reply Thom, my issue got solved..

-Yojas

[tmumaw]

Your welcome Yojas.  Have a great day.