Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
cesarbadill8
Contributor III
Contributor III

Expressions colors

Hi all, I am trying to create an expression to show me the negative values in red and the positive values in blue, this is the expression I am sending:

cesarbadill8_0-1664550882290.png

But I see that it takes me positive values in red, thank you very much, I appreciate your help.

cesarbadill8_1-1664550942083.png

 

 

Labels (4)
2 Replies
sidhiq91
Specialist II
Specialist II

@cesarbadill8 Can I know why is it sum(MesM='01')>='0'?  what does this expression do?

Your expression should be

if(sum(MesM='01')>='0',Blue(), red())

Let me know if you have any questions.

deepanshuSh
Creator III
Creator III

Don't you think it should be set expression here;

 

Sum({<Mesm={'01'}>}MesM) if its on front end 

 

Trial and error is the key to get unexpected results.