How to convert an expression to be selection insensitive?

[#1]

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 .

Region	Zip	InvoiceCount
A	A123	2
A	A321	1
B	B234	4
C	C345	6

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

[sunny_talwar · Accepted solution]

Try this:

Count(DISTINCT {1<Region = {"=Sum({1} InvoiceCount) < 6"}>} Region)

or this

Count(DISTINCT {1<Region = {"=Sum(InvoiceCount) < 6"}>} Region)

[#3]

Hi Sunny,

Thanks; the first one has the desired effect. Now I just need to understand how it works