Discussion board where members can learn more about Qlik Sense App Development and Usage.
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?
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.
View solution in original post
There looks to be multiple percent targets. Trying to refer to a field with multiple values in the singular will result in null.
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.
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.