Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
In VBA I can change criteria based on different conditions. Can I do the same in Qlik Sense?
Eg. I want to show Types where count of IDs are less than 10 normally, but want to change the criteria of 10 to 3 if something in Region or City is selected. So in normal cases the expression will be:
if(aggr(count(ID), Type)>10,Type)
How can I make it flexible to accommodate scenarios where something in Region or City is selected?
Thanks in advance!
May be use an extension to set value of a variable