Qlik Community

New to Qlik Sense

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

Qlik Insider: SaaS capabilities for Data Integration and Analytics, May 25th! Register Now
Showing results for 
Search instead for 
Did you mean: 

KPI does not reflect the correct count when a filter is applied


I have 5 KPIs listed.

KPI 1 = Severity Level count for Level 1

KPI 2 = Severity Level count for Level 2

and so on until Level 5.

With no selection of any filters, the total count is correct. It is only when I filter by another item, for example, 'Month" that the count is not reflected correctly. Sometimes the numbers are updated but the number is not accurate.

Is there a way to fix this issue?

Like if I select severity levels 2-5, the severity level 1 should display '0' not the total severity level 1 counts.


3 Replies

I'm sure there's a way to fix it. Unfortunately most of us are not clairvoyant so we don't know how to fix your expressions unless we can look at them and the data model of your Qlik Sense app.

talk is cheap, supply exceeds demand

count({<[Severity Flag]={'Level 1'}>} [IncidentID])

this is the formula I put into the KPI to show the count for the 1st KPI


Ok, so [Severity Flag]={'Level 1'} will always make the expression ignore user selections in the field Severity Flag and always apply the value Level 1. If you don't want that you can try using [Severity Flag] *= {'Level 1'} to intersect the user selection with the value Level 1. If the user selection excludes Level 1 then the result of the expression will be 0.

talk is cheap, supply exceeds demand