Signal Light type visualization in the Straight Table

[Anonymous · Accepted solution]

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

[Anonymous · Accepted solution]

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

[#3]

Hi Michel, Thanks for reply and works perfect.

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

[#4]

Hi Michel, Thanks for reply and works perfect.

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

[Anonymous]

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

[Anonymous]

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

[#7]

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.

[#8]

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.

[Anonymous]

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

Regards,

Michael

[Anonymous]

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

Regards,

Michael