Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

change of data colors on map with expression

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())

12 Replies
Not applicable
Author

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.

Anonymous
Not applicable
Author

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

Not applicable
Author

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.