Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.