Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
gino2780
Not applicable

Fixed KPI - Count ignoring all filter selections

Hi all,

i'm looking for a script command that allows me to create KPI's that (e.g. Count, Sum) always stay the same, although i might have selected certain filters on the Dashboard. My idea is to visualize on one Dashboard fixed KPI's for overall perspective vs. dynamic KPI's (that change with each filter selection) for specific or more detailed KPI's.

Let's say my data consists of 1000 rows. Each row is a customer. Let's say the field is named 'Customers' next to many other fields (columns) in a given set of data. I always want to see the Count of Customers = 1000 in the KPI, no matter which filters i have selected at the same time.

I've looked for some hints here in this forum, but couldn't find the solution.

Thanks in advance,

bye bye

1 Solution

Accepted Solutions
sunny_talwar
Not applicable

Re: Fixed KPI - Count ignoring all filter selections

Using {1} is the key here as pointed out by shraddha.g‌.

Count({1} CustomerID)

3 Replies
shraddha_g
Not applicable

Re: Fixed KPI - Count ignoring all filter selections

you can ignore all selections in Set Analysis.

For Ex. Sum({1}Sales)

It wont change on any selection.

sunny_talwar
Not applicable

Re: Fixed KPI - Count ignoring all filter selections

Using {1} is the key here as pointed out by shraddha.g‌.

Count({1} CustomerID)

gino2780
Not applicable

Re: Fixed KPI - Count ignoring all filter selections

Works perfectly fine.

Thanks Shraddha and Sunny