topic Visual cues for text values in QlikView

Visual cues for text values

Mon, 19 Nov 2012 14:45:14 GMT

Hi:

I want to show green,red and yellow colors based on the text values.

If say status = G, display the cell in green color

if the status = R,display the cell in red color

If status = Y, display the cell in yellow color.

I have created straight table and used G,R and Y as expression since visual cues work only with numeric values

but cannot get the respective colors for G,R and Y.

Since Visual cues work only with numeric values, i have also tried to put the following in the expression

if (Status = 'G',Green(),red ())

if (Schedule = 'G',RGB(0,128,0),red ())

but not getting the right result.

Can you please help.

Re: Visual cues for text values

shree909 — Mon, 19 Nov 2012 14:50:29 GMT

Hi,

when u go to the expression u fiond a '+' sign , when u expand that u will see options to change the

1)text format

2)Text color

in text color u write the expression

if (Status = 'G',Green(),

if (status ='R' , red(),yellow())

Re: Visual cues for text values

jagan — Mon, 19 Nov 2012 14:51:36 GMT

HI,

PFA file hope it helps you.

Regards,

Jagan.

Re: Visual cues for text values

MayilVahanan — Mon, 19 Nov 2012 14:52:04 GMT

In the expression tab, you can see the '+' sign. By clicking it, you can see background color, text color.. According to your requirement, choose any one of them, and put the expression like this

if (Status = 'G',Green(),red ())

hope it helps

Re: Visual cues for text values

Mon, 19 Nov 2012 15:20:50 GMT

Thank you all.

It worked.

Thanks for the sample.