Qlik Community

New to Qlik Sense

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

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
gino2780
Creator
Creator

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

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

Count({1} CustomerID)

View solution in original post

4 Replies
shraddha_g
Partner - Master III
Partner - Master III

you can ignore all selections in Set Analysis.

For Ex. Sum({1}Sales)

It wont change on any selection.

sunny_talwar

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

Count({1} CustomerID)

gino2780
Creator
Creator
Author

Works perfectly fine.

Thanks Shraddha and Sunny

Murthy
Contributor
Contributor

Hi,

I have prepared a dashboard, which has Month, Function, volumes, Error .

And once i apply filter on Month and Function , The volumes what i get should not get change even if i apply further filetr.

Kindly can you tell how to fix this.