Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

jcampbell
Not applicable

KPI Limit = Value of Percentage

I'm having trouble trying to get the right limit set on conditional coloring on a KPI. My KPI is calculating the number of errors from the previous month using the following measure:

Sum({<[Month]={'$(vMonthPrevious)'}>}[Errors])

Now I wanted to add a limit to color the value Red if the percentage of errors is greater than 0.001 (e.g. 1/1000). The following measure returns the percentage but now I need to color based on that percentage being greater than 0.001:

=Num(Sum({<[Month]={'$(vMonthPrevious)'}>}[Errors])) / Num(Sum({<[Month]={'$(vMonthPrevious)'}>}[Transactions]))

Any help would be appreciated. Thanks!

2 Replies
brunobertels
Not applicable

Re: KPI Limit = Value of Percentage

Hi

In your KPI object you should have this for conditionnal color

just Try to put 0.001

jcampbell
Not applicable

Re: KPI Limit = Value of Percentage

It didn't seem to work. I actually made it 0.03 to try to get it to employ the conditional formatting - but no success. See attached.

Screen Shot 2016-02-12 at 8.21.35 AM.png