topic Re: Pivot table traffic light guage in QlikView

Pivot table traffic light guage

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

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 ?

Thanks in Advance

zhadrakas — Thu, 14 May 2020 07:30:36 GMT

you can do this by

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

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 — Thu, 14 May 2020 10:25:44 GMT

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

zhadrakas — Thu, 14 May 2020 10:33:45 GMT

that should explain it