Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.


Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Honored Contributor III

Color condition issue

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.



1 Reply

Re: Color condition issue

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)

Community Browser