Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Insider: SaaS capabilities for Data Integration and Analytics, May 25th! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
ioannagr
Creator III
Creator III

colour measure by conditional expression question

Hello everyone.

I have a set a limit by a conditional expression to a measure. Over this limit the colour is green, under it is red.

When the measure is zero it's still green coloured!

How do i change it to be a neutral colour? Say blue?

3 Replies
GaryGiles
Specialist
Specialist

It depends on what type of chart object you are using and where you setting your limit by conditional expression.  If you are using a basic if statement where you can specify a color, why not:

if(expression=0,blue(),if(expression<0,red(),green())

ioannagr
Creator III
Creator III
Author

Hello, yes my bad, I forgot to mention, It's a simple KPI so maybe the above doesn't work? What do you suggest @GaryGiles ?

GaryGiles
Specialist
Specialist

You can set multiple limits in the KPI Conditional colors.  Have 2 limits.  One at -.000001 and the other at .000001 (or whatever preciseness your data requires) .  You will have an option to set 3 colors.  Left Red, middle Blue and right green.  

BTW, this can be a little tricky.  You may to start at -1 and 1 so that you can easily distinguish between the two limits and then change the values to -.000001 and .000001.