topic Re: Indicators with strings in QlikView

Indicators with strings

Fri, 16 Jan 2015 15:31:59 GMT

Hi.

I have this expression

if(Number1 <0, 'OK',

if(Number2< 31, 'Not Ok', 'OK2'))

Now i wanna do this with an traffic light indicator? i dont know how to say this in english.

is like the blue or red light

if OK = red

etc...

how i do this? it works with numbers but it doesn't work with strings.

Thank ya!

Re: Indicators with strings

Gysbert_Wassenaar — Fri, 16 Jan 2015 15:40:08 GMT

Click on the + sign in front of the expression and select Background Color. Then enter an expression to calculate a color. Something like =pick(match(MyField,'Ok','Not Ok','OK2'),lightgreen(),lightred(),lightblue())

Re: Indicators with strings

Fri, 16 Jan 2015 15:48:09 GMT

Ok thank you, but i was speaking about something like this

Re: Indicators with strings

Fri, 16 Jan 2015 15:56:10 GMT

Did you understand?I dont know if i was clear

Re: Indicators with strings

Gysbert_Wassenaar — Fri, 16 Jan 2015 16:06:11 GMT

See attached example.

Re: Indicators with strings

Fri, 16 Jan 2015 16:45:05 GMT

Thank you