Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello I need create an expression that displays data in colors that change according to it's values, for exemple red if it's negative and green if it's positive, I have created the expression and added the condition in the background color section of the expression but it doesn't seem to work, QlikView forces the default colors. what should i do. the condition is
if(expression>=0, green(), red())
HELLO everyone, I have tried to put the color expression in the background part of longitude and it does work. but it only shows the positive values(green), the negative values don't show(red spots). thanks in advance for your help.
I don't think you can display negative-sized bubbles. You can make them all positive by changing the expression to:
fabs( expression )
and marking the negative ones with red colour:
if ( expression>0, green(), red() )
But make sure the users won't find it confusing...
Dilyana
yes you're right Dilyana, thank you so much, i just added a text box explaining the difference between the red and the green bubbles. I want to thank each and everyone of you for your support. I appreciate it. have a nice and productive day.