Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
smilingjohn
Specialist
Specialist

Pivot table traffic light guage

Hi All,

I have to create a gauge chart with dimension Department and expression sum(Sales) 

in expression i have to show traffic lights rather than numbers .  like below  for  .Is it possible to achive this ?

smilingjohn_0-1589435842647.png

Thanks in Advance 

1 Solution

Accepted Solutions
zhadrakas
Specialist II
Specialist II

that should explain it

zhadrakas_0-1589452412633.png

 

View solution in original post

3 Replies
zhadrakas
Specialist II
Specialist II

you can do this by

zhadrakas_0-1589441195265.png

change Representation to "trafic light gauge" and click on "gauge settings"

zhadrakas_1-1589441253101.png

there create your 4 segments.

Disable "autowidth Segments"

Set min and mix static if you like. to do it dynamic you can use something like this

min(aggr(NODISTINCT sum(Sales), Your_Dimension))
max(aggr(NODISTINCT sum(Sales), Your_Dimension))

Set your min values for each segment at "Lower Bound"

Set your colors for each segment

 

regards

tim

smilingjohn
Specialist
Specialist
Author

Thanks @zhadrakas 

 

How do i add the min values to the segment it is not taking .All mi values are considering same . 

I am attaching my QVW file 

 

I want to show the below indication 

Cosmatics10Red
Choclates20Green
Sports30Yellow
Finance10Red
Wiring50orange 
zhadrakas
Specialist II
Specialist II

that should explain it

zhadrakas_0-1589452412633.png