topic Re: Dynamic color coding KPI Percent values in App Development

Dynamic color coding KPI Percent values

mohamedafzal — Tue, 26 Jul 2022 05:37:34 GMT

I have a KPI chart in Qlik Sense with general percent calculation. Sum(SLA) / Sum(Total SLA) . I change it to '%' using the Number formatting in the KPI chart.

I need to color code the KPI percent based on the Target column. If I hardcode as '50%' in 'Conditional colors' adding a limit it is working fine. (Target1.png)

However, when I use 'Percent_Target' column in the limit, I get a message 'You can use this setting to represent numeric measure values only'. (Target2.png)

Percent_Target column from excel is shown in Target3.png

Could someone please assist on this?

Re: Dynamic color coding KPI Percent values

Or — Tue, 26 Jul 2022 08:07:39 GMT

There looks to be multiple percent targets. Trying to refer to a field with multiple values in the singular will result in null.

Re: Dynamic color coding KPI Percent values

fallenangel6 — Tue, 26 Jul 2022 09:48:42 GMT

It could be because Percent target isn't a number. please try changing percent target to 0.05,0.02,0.1 etc instead of 5%,2% ,10% etc. it should work.

Re: Dynamic color coding KPI Percent values

mohamedafzal — Thu, 28 Jul 2022 10:57:54 GMT

I did change the Target to 0.05, 0.02 initially. But the KPI value which I am comparing for conditional formatting is % KPI which again giving the same error message.

Re: Dynamic color coding KPI Percent values

mohamedafzal — Thu, 28 Jul 2022 10:59:15 GMT

Instead of using the 'Percent_Target' for color coding, I gave as Avg(Percent_Target) which solved the issue. Based on the country which I select the color coding worked.