topic Re: how to change single light traffic light guage color in straighttable in qlikview? in QlikView

how to change single light traffic light guage color in straighttable in qlikview?

Mon, 08 Sep 2014 10:46:07 GMT

hi,

I have done straight table with traffic light gauge But That traffic light gauge colour did not change .I want to change that color in straight table but I do not know how to change that traffic light gauge colour in straight table.please tell me out how to change traffic light colour in straight table .

I attached snipping file below this box. tell me out how to change color in straight table.

Thank you

Regards:

madhu

Re: how to change single light traffic light guage color in straighttable in qlikview?

maxgro — Mon, 08 Sep 2014 11:15:11 GMT

select the expression

click Gauge Settings

in the new window set min, max e gauge settimgs

see attachment (.qvw) and image

you can find another example in kpi tab of Data Visualization.qvw, usually on C:\Program Files\QlikView\Examples\Documents

Re: how to change single light traffic light guage color in straighttable in qlikview?

ashfaq_haseeb — Mon, 08 Sep 2014 11:18:33 GMT

Hi,

have a look at attached application.

Regards

ASHFAQ

Re: how to change single light traffic light guage color in straighttable in qlikview?

Mon, 08 Sep 2014 15:51:16 GMT

thanks massimo I followed your direction but it does not work ple help me massimo.

see this image.

Regards:

madhu

Re: Re: how to change single light traffic light guage color in straighttable in qlikview?

maxgro — Mon, 08 Sep 2014 18:25:33 GMT

if you want to use 0 e 1as minimum and maximum you have to use an expression with result between 0 and 1

so replace sum(Price) for traffic light expression with (sum of price of the row / maximum sum of price ....)

sum(Price) / max(total aggr(sum(Price), Product))

for lower bound use

segment 1 red 0

segment 2 yellow 0.2 20%: yellow when sum of price of the row is gt than 20% of max sum of price)

segment 3 green 0.4 40%: green .................

this is an example, adapt to your logic or requirements

in the attachment you find the new chart on the right

Re: how to change single light traffic light guage color in straighttable in qlikview?

Tue, 09 Sep 2014 02:27:58 GMT

thank you massimo

Re: how to change single light traffic light guage color in straighttable in qlikview?

Tue, 09 Sep 2014 02:28:20 GMT

thank you ashfaq

Re: how to change single light traffic light guage color in straighttable in qlikview?

ashfaq_haseeb — Tue, 09 Sep 2014 06:26:51 GMT

Hi,

Can you close this thread by selecting appropriate answer.

Regards

ASHFAQ