Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
vijetas42
Specialist
Specialist

Visual Cues

Hi All,

I need your help on visual cues expression. My scenario is to show values which are negative that should display in red and values that are positive that should get display In green.

I have given condition >=0.0 and <=-0.001.but, it's not working when I am having values -0.0 it get displayed in black. Please suggest your opinions.

Thanks!


6 Replies
PradeepReddy
Specialist II
Specialist II

in condition u skipped for the value '0.0'.

Try something like this..

Value>=0.0 then green color

Value<0 then red color

Not applicable

Use expression

campt.JPG

vijetas42
Specialist
Specialist
Author

Hey,

Thanks for your reply but it's not working when I have value as 0.0 then its not working.

awhitfield
Partner - Champion
Partner - Champion

Hi,

If you are using the Visual Clues option in properties set to 0.0 as Upper and -0.0001 as lower, you can't have -0.0

Andy

vijetas42
Specialist
Specialist
Author

Hi Andrew,

Ya, I have also tried the same expression and it's working but I am not sure about how long it will work.

Thanks!

awhitfield
Partner - Champion
Partner - Champion

Hi Vijeta,

if you are happy with a reply, then please mark it as CORRECT, so that other Community Members know that the issue is resolved

Andy