Set Analysis with $ ignores Selection

[Maike151]

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: 

Select dimension1 = b:

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

[Or · Accepted solution]

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:

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

[Maike151]

Thank you so much!