Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Partner
Partner

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

Hi,

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.

Thanks.

3 Replies
MVP & Luminary
MVP & Luminary

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

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
Highlighted
Partner
Partner

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

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

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

MVP & Luminary
MVP & Luminary

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

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