This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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