Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
Not applicable

Signal Light type visualization in the Straight Table

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

1 Solution

Accepted Solutions
mov
Esteemed Contributor III

Re: Signal Light type visualization in the Straight Table

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

5 Replies
mov
Esteemed Contributor III

Re: Signal Light type visualization in the Straight Table

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

Not applicable

Re: Signal Light type visualization in the Straight Table

Hi Michel, Thanks for reply and works perfect.

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

mov
Esteemed Contributor III

Re: Signal Light type visualization in the Straight Table

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

Not applicable

Re: Signal Light type visualization in the Straight Table

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.

mov
Esteemed Contributor III

Re: Signal Light type visualization in the Straight Table

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

Regards,

Michael