Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
3 Keynotes, 100+ Breakout Sessions, 1 New York Times bestseller, and you. QlikWorld Online, May 10-12: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to convert an expression to be selection insensitive?

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

1 Solution

Accepted Solutions
sunny_talwar

Try this:

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

or this

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

View solution in original post

2 Replies
sunny_talwar

Try this:

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

or this

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

View solution in original post

Not applicable
Author

Hi Sunny,

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