Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
smilingjohn
Creator III
Creator III

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
Creator III
Creator III
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

 

View solution in original post