topic Re: List Box with Traffic Lights in QlikView

List Box with Traffic Lights

Thu, 18 Sep 2014 10:42:47 GMT

I have a field called "Sig" - there are 3 values :

-1

I want to create a list box with 3 traffic lights instead of values that I can filter on.


Green traffic light (Value=1)	Yellow Traffic light (Value=0)	Red Traffic light Yellow Traffic light (Value=-1)

Seem to be having trouble achieving this.

Thanks

Re: List Box with Traffic Lights

Gysbert_Wassenaar — Thu, 18 Sep 2014 11:21:37 GMT

Use an expression for the listbox:

=if(Sig=-1,'qmem://<bundled>/BuiltIn/led_r.png',if(Sig=0,'qmem://<bundled>/BuiltIn/led_y.png','qmem://<bundled>/BuiltIn/led_g.png'))

Then on the Presentation tab change the Representation from Text to Image.You may also want to change the Image Formatting setting and the Multiline settings.

See attached qvw

Re: List Box with Traffic Lights

MayilVahanan — Thu, 18 Sep 2014 11:42:49 GMT

Try like this also

list box expression

Pick(Match(Sig,-1,0,1),'qmem://<bundled>/BuiltIn/led_r.png','qmem://<bundled>/BuiltIn/led_y.png','qmem://<bundled>/BuiltIn/led_g.png')

Then on the Presentation tab change the Representation from Text to Image

Image formatting - Keep aspect

Re: List Box with Traffic Lights

Thu, 18 Sep 2014 15:39:00 GMT

Silly question …..but your links… 'qmem:///BuiltIn/led_r.png'

Do I need to save an image of each traffic light on my computer and then link to the expression?

Re: List Box with Traffic Lights

fkeuroglian — Thu, 18 Sep 2014 17:23:26 GMT

Yes Roderick, you have to have the correct root for all the pictures you will use in the local pc or the server

Re: List Box with Traffic Lights

Thu, 18 Sep 2014 18:56:38 GMT

Excellent- thanks guys. Two last questions : 1.) Can I centre the images? (I have hidden the test and they show up on the right of the list box) 2.)Can I hide the null selection so that it just shows my three traffic lights? Thanks!