2 Replies Latest reply: Feb 28, 2017 12:16 PM by Craig Nicholas RSS

    How to convert an expression to be selection insensitive?

    Craig Nicholas

      Hi

      I'm quite new to Qlik Sense so bear with me

       

      I want to convert the following expression that I am using in a KPI object to be selection insensitive.

       

        sum(if(6>Aggr(sum(InvoiceCount), Region),1,0))

       

      Using the following test data it displays the value 2 when applied to all data i.e. the count of regions with total InvoiceCount < 6 .

       

      RegionZipInvoiceCount
      AA1232
      AA3211
      BB2344
      CC3456

       

      I've been trying to use set analysis expressions to convert it so it is not selection sensitive but no luck so far.

       

      Any pointers will be very welcome.

       

      Craig