Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello experts,
I can't seem to solve this: I created a KPI with a set analysis inside the measure. Then in a filter pane, I filtered by that same dimension but the KPI doesn't change.
For example, the dimension is Alert, and it can be RED, YELLOW or GREEN; and the KPI measure: count(<{Alert={'RED'}>}Tickets); Then if I use a filter pane with the Alert dimension and chose GREEN, the KPI remains the same value. It only changes when I apply a different type of dimension, such as date, office, product, etc.
This has to be related on how Qlik evaluates the set analysis. Any thoughts?
Thanks
Try an expression like this:
count({<Alert *= {'Green'}>}Tickets) //* indicates union with your current selection in the field
This is how Qlik evaluates SET analysis.
In your example count(<{Alert={'RED'}>}Tickets) you are basically saying "count all Tickets using my current selection, but force the selection on the field Alert to be RED."
I'm courious, what would you expecting as result from your expression using Alert={'Red'} when selecting GREEN?
Hello Vegar,
So basically I have three KPI showing each of the options (RED, YELLOW and GREEN). If I select GREEN on the filter pane, I just want to show the GREEN tickets. So the RED and YELLOW KPI should show 0.
Thanks
This you can achieve it using Qlik's default functionality.
With expression Count(Ticket), if you select particular Alert, it will automatically display the value for that particular alert. But if nothing is selected and you want default to Red and then based on selection you want to change then you can do something like below
=if(getselectedcount(Alert)=0,Count({<Alert={'Red'}>}Ticket),Count(Ticket))
Try an expression like this:
count({<Alert *= {'Green'}>}Tickets) //* indicates union with your current selection in the field
Brilliant! it's exactly what I need
@Vegar Don't know but somehow this *= does not work in Qlik sense
@Vegar sorry actually I misunderstood. I thought requirement is to show KPI using single object. But here it required 3 KPI objects. Anyway thanks.
I assume my solution fits his/her needs as @MEBG93 marked my answer as a accepted solution.