Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Specialist II
Specialist II

Re: Pivot table traffic light guage

that should explain it

zhadrakas_0-1589452412633.png

 

View solution in original post

3 Replies
Highlighted
Specialist II
Specialist II

Re: Pivot table traffic light guage

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

Highlighted
Creator III
Creator III

Re: Pivot table traffic light guage

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 
Highlighted
Specialist II
Specialist II

Re: Pivot table traffic light guage

that should explain it

zhadrakas_0-1589452412633.png

 

View solution in original post