topic Re: Visual Cues in QlikView

Visual Cues

vijetas42 — Mon, 27 Apr 2015 12:47:01 GMT

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!

Re: Visual Cues

PradeepReddy — Mon, 27 Apr 2015 12:51:24 GMT

in condition u skipped for the value '0.0'.

Try something like this..

Value>=0.0 then green color

Value<0 then red color

Re: Visual Cues

Mon, 27 Apr 2015 12:52:01 GMT

Use expression

Re: Visual Cues

vijetas42 — Mon, 27 Apr 2015 13:12:56 GMT

Hey,

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

Re: Visual Cues

awhitfield — Mon, 27 Apr 2015 13:22:38 GMT

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

Re: Visual Cues

vijetas42 — Mon, 27 Apr 2015 13:29:59 GMT

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!

Re: Visual Cues

awhitfield — Mon, 27 Apr 2015 14:57:57 GMT

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