topic Re: Set Analysis with $ ignores Selection in App Development

Set Analysis with $ ignores Selection

Maike151 — Thu, 23 Mar 2023 12:41:36 GMT

Dear Qlik Community,

I am using 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

Re: Set Analysis with $ ignores Selection

Or — Thu, 23 Mar 2023 12:52:15 GMT

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/SetAnalysis/set-modifiers-using-assignments-implicit-set-operators.htm

Re: Set Analysis with $ ignores Selection

Maike151 — Thu, 23 Mar 2023 13:03:17 GMT

Thank you so much!