topic Re: Signal Light type visualization in the Straight Table in QlikView

Signal Light type visualization in the Straight Table

Mon, 26 Nov 2012 20:14:41 GMT

Hi Folks, In my Straight Table, I need to show the satus of my product like Traffic Signal. If my product status is 'Released' and I show Green Signal and the product status is 'Waiting' and I show the Red Signal in my expression.

Please find the attched application and Please help me on this..

Thanking in Advance .....

Thanks & Regards,

Siri

Re: Signal Light type visualization in the Straight Table

Anonymous — Mon, 26 Nov 2012 20:29:40 GMT

Siri,

You don't need a gauge representation in this case. Use image representation, and the expression is:

if(Status='Released',
'qmem://<bundled>/BuiltIn/led_g.png',
'qmem://<bundled>/BuiltIn/led_r.png')

And, in image formatting, choose "keep aspect"

Regards,

Michael

Re: Signal Light type visualization in the Straight Table

Mon, 26 Nov 2012 21:21:43 GMT

Hi Michel, Thanks for reply and works perfect.

I wonder, How can we do this with Traffic Light style type.

Re: Signal Light type visualization in the Straight Table

Anonymous — Mon, 26 Nov 2012 21:31:41 GMT

Siri,

You can do it with the traffic light gauge as well, I just think it is simple with image.

To make your traffic light work, make the next changes in your gauge settings:

- add one more segment (it will be red by default)

- uncheck "autowidth segments" on the left bottom corner

- set lower bound for the green segment 0 (in fact, anything less than 1)

- set lower bound for the red segment 1.5 (anyhting >1 and <2)

Regards,

Michael

Re: Signal Light type visualization in the Straight Table

Mon, 26 Nov 2012 21:42:56 GMT

Thanks Michel.

Where can I find the other images in theis path "qmem://<bundled>/BuiltIn/"

I check my ProgramFiles\Qlikview\ and I didn't find it and I am using QV11 with 32 bit.

Re: Signal Light type visualization in the Straight Table

Anonymous — Mon, 26 Nov 2012 21:45:30 GMT

In "edit expression", see "Images" tab on the bottom. Qlik button "Advanced" to get the images.

Regards,

Michael