Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi,
have a look at attached application.
Regards
ASHFAQ
thanks massimo I followed your direction but it does not work ple help me massimo.
see this image.
Regards:
madhu
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
thank you massimo
thank you ashfaq
Hi,
Can you close this thread by selecting appropriate answer.
Regards
ASHFAQ