Color condition issue

amit_saini — Tue, 17 May 2016 11:32:06 GMT

Hi Folks ,

Below is my condition :

if (sum(Act)<sum(AOP),lightred())

This is user requirement to show data upto 1 decimal , but if I'm doing this , I'm getting red colors if Act = AOP

but from the second picture this is clear than Act value is less than AOP and hence showing red numbers.

How can I handle color based on format , just want to show upto 1 decimal.

So in case of KHE "95.2%" should be black and not red.

Thanks,

Re: Color condition issue

sunny_talwar — Tue, 17 May 2016 11:38:38 GMT

May be this:

If(Round(Sum(Act), 0.001) < Round(Sum(AOP), 0.001), LightRed())

UPDATE: I am sure if Act and AOP are percentages or not, but the idea is to use Round() function here. To what place to round it to, you can decide based on your data (either 0.1 or 0.001)

topic Color condition issue in QlikView

Color condition issue

Re: Color condition issue