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!