topic Re: Replacing text with icons (colored led) in QlikView

Replacing text with icons (colored led)

Thu, 10 Jan 2013 10:20:45 GMT

Hi there,

I have several table boxes

I have a status column which is On time / Late / At risk

I would like to replace the text with some icons, for exemple colored leds (green = On Time / Red = Late / At Risk = Yellow)

What should I do in order to implement this ?

Regards,

Re: Replacing text with icons (colored led)

Gysbert_Wassenaar — Thu, 10 Jan 2013 10:35:37 GMT

Something like this:

pick(match(Status,'On time','Late','At risk'),'qmem://<bundled>/BuiltIn/led_g.png','qmem://<bundled>/BuiltIn/led_r.png','qmem://<bundled>/BuiltIn/led_o.png')

You can select the builtin images on the Images tab of the expression editor.

Re: Replacing text with icons (colored led)

Thu, 10 Jan 2013 10:43:17 GMT

Thanks for the quick reply, but I don't know where to put that expression....

Which tab from my table box properties ?

Re: Replacing text with icons (colored led)

Gysbert_Wassenaar — Thu, 10 Jan 2013 12:34:38 GMT

You can't put it in a table box, you'll have to use a straight table or pivot table and add it as an expression or calculated dimension.

Re: Replacing text with icons (colored led)

Mon, 28 Apr 2014 18:41:40 GMT

Thanks it worked