Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Maike151
Contributor II
Contributor II

Set Analysis with $ ignores Selection

Dear Qlik Community,

I am using Qlik Sense Enterprise on Windows  November 2022 Patch 2 and I am facing the following bug (?)

I load a table like this:

 

 

test:
Load * Inline [
dimension1, dimension2, measure
a, 1, 10
a, 2, 20
b, 1, 30
b, 2, 40
];

 

 

And then I define a measure like this:

 

 

Sum({$<dimension1={'a'}>} measure)

 

 

Now, when I select dimension b in the sheet, I would expect my measure to become zero. But the following happens:

No selection, everything as expected: 

Maike151_0-1679574903020.png

 

Select dimension1 = b:

Maike151_1-1679574941885.png

Is this the desired behavior? I would expect this if I used a "1" instead of the "$". What do I have to do to get back zero when I filter a different value?

Thank you in advance!

Maike

Labels (1)
1 Solution

Accepted Solutions
Or
MVP
MVP

Using the = operator in set analysis means it overrides any existing selections on the field. Using *= means it will intersect the current selection with the value:

Or_1-1679575912986.png

 

https://help.qlik.com/en-US/qlikview/May2022/Subsystems/Client/Content/QV_QlikView/ChartFunctions/Se...

 

 

 

View solution in original post

2 Replies
Or
MVP
MVP

Using the = operator in set analysis means it overrides any existing selections on the field. Using *= means it will intersect the current selection with the value:

Or_1-1679575912986.png

 

https://help.qlik.com/en-US/qlikview/May2022/Subsystems/Client/Content/QV_QlikView/ChartFunctions/Se...

 

 

 

Maike151
Contributor II
Contributor II
Author

Thank you so much!