1 Reply Latest reply: Dec 14, 2016 6:27 PM by Sunny Talwar RSS

    How to change criteria based on selection

    jade wind

      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!