

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Using Not Equal condition in Set Analysis
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)
Accepted Solutions
.png)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
.png)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you very much. It was exactly what I was looking for.
Thom

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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...

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Yojas,
Try this
Count({<citizenship_StdPersonalInfo -= {'Singapore'} + isPR_StdPersonalInfo={0}>}DISTINCT(stdApplicationNo))
Thom

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks for Reply Thom, my issue got solved..
-Yojas


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Your welcome Yojas. Have a great day.
