topic Re: Set expression to be modified depending on whether the user has filtered on a specific dimension in App Development

Set expression to be modified depending on whether the user has filtered on a specific dimension

udden2903 — Tue, 05 Apr 2022 19:15:49 GMT

Dear all,

I have a set expression that will need to be modified depending on whether the user has applied a filter on a specific dimension in my app. The expression looks as follows, where vValue should assume the value of 1 or otherwise be "disabled" depending on whether the user has made a selection on the dimension TerritoryID:

Sum ( {$<MyVariable = vValue>} Sales )

The expression should be evaluated as follows:

If GetSelectedCount(TerritoryID) > 0, then
Sum ( {$<MyVariable = {1}>} Sales )

Otherwise
Sum ( {$<MyVariable = >} Sales )

Combining the above in one If...Then statement will not work for my purposes.

/ Andreas

Re: Set expression to be modified depending on whether the user has filtered on a specific dimension

rwunderlich — Tue, 05 Apr 2022 20:06:25 GMT

Create a new variable, preferably in the script like this:

Set vChooseMyVariable = =if (GetSelectedCount(TerritoryID) > 0, '{1}', '');

Note there are two "=" in the above.

Then your expression will be:

Sum ( {$<MyVariable = $(vChooseMyVariable)>} Sales )

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

Re: Set expression to be modified depending on whether the user has filtered on a specific dimension

udden2903 — Thu, 07 Apr 2022 11:48:05 GMT

Thanks - works well.

/ Andreas