topic Set Analysis Ignore Selections not working in Qlik Sense Cloud in Data Movement & Streaming

Set Analysis Ignore Selections not working in Qlik Sense Cloud

Jean-R-Balde — Wed, 19 Mar 2025 23:08:30 GMT

Hi there,

I have the following expression: sum({$<[Trading Year] = {$(vMaxTYear)}, [Trading Month] = {$(vMaxTMonth)}, [Trading Day in Year] = {"<=$(vMaxTDay)"}, [Year] = , [Month Year] = >} [Sales Value @LSP])

This expression is supposed to ignore any selection done on [Year] and [Month Year]. However, my numbers change when I do a selection on [Year].

Is this a bug, or am I doing something wrong?

Regards,

Jean

Re: Set Analysis Ignore Selections not working in Qlik Sense Cloud

hic — Fri, 15 Jul 2022 11:52:06 GMT

I doubt that there is a bug here...

How are vMaxTYear, vMaxTMonth and vMaxTDay calculated? Do they depend on [Year] or on a field that changes when a selection is made in [Year]?

Re: Set Analysis Ignore Selections not working in Qlik Sense Cloud

Jean-R-Balde — Sat, 16 Jul 2022 06:13:40 GMT

Hi there.

Thanks for your reply. vMaxTYear, vMaxTMonth and vMaxTDay are not dependent on [Year]. They do depend on fields that change when selections are made in [Year]. However, this should not be an issue because all selections made on [Year] should be ignored even in other fields.

Re: Set Analysis Ignore Selections not working in Qlik Sense Cloud

hic — Mon, 18 Jul 2022 06:36:43 GMT

No, that's not how it works.

If the variables are defined through expressions, they are evaluated from current selection. I.e. the variable values can change when you make selections.

The set expression will create a new selection which is used for that specific aggregation, and in your set expression the selection in [Trading Year], [Trading Month], and [Trading Day in Year] depend on current selection:

[Trading Year] = {$(vMaxTYear)},
[Trading Month] = {$(vMaxTMonth)},
[Trading Day in Year] = {"<=$(vMaxTDay)"},

So, your calculation may well change when you make a selection in [Year].

Re: Set Analysis Ignore Selections not working in Qlik Sense Cloud

Jean-R-Balde — Tue, 19 Jul 2022 05:17:53 GMT

Hi Henric.

Thanks for your feedback. It is very helpful.

If the variables are defined through expressions and are evaluated from current selection, how can I change it to create MTD and YTD expressions? Do I also need to specify [Year] = , [Month] = inside the variable definition?

Re: Set Analysis Ignore Selections not working in Qlik Sense Cloud

hic — Tue, 19 Jul 2022 06:38:49 GMT

Yes, if you want your variables to be independent from your selection in these fields, then you need to specify "[Year] = , [Month] = " also inside the variable definition.

Re: Set Analysis Ignore Selections not working in Qlik Sense Cloud

Jean-R-Balde — Thu, 21 Jul 2022 08:40:56 GMT

Thank you very much for your help, Henric.