Discussion board where members can get started with QlikView.
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
that should explain it
View solution in original post
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
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