Traffic lights settings

Thu, 01 Aug 2013 07:42:29 GMT

We use traffic lights in comparison with previous years, in the following case it is on the margin.
Now I would like to see when the percentage margin is negative, the meter is red, when it is positive the meter is green, and when it is 0, the meter is gray.
Now I've been working with the meter characteristics, but I fail to get the settings right.
Because if I add Segment 3 (gray) with a lower limit of 0, and change the lower limit of Segment 2 (green) to 0.01, then he turns red in the table.

See also attached files.
Can someone help me with the correct settings? And is my formula correct?

Margin Variance:

If([Margin %
$(vPriorYear)]=0,0,([Margin %
$(vMaxYear)] - [Margin %
$(vPriorYear)]) / fabs([Margin %
$(vPriorYear)]))

//If statement needed for situation vPriorYear = 0
//fabs statement needed for situation vPriorYear negatief

Thanks in advance!

Mirjam

Re: Traffic lights settings

Thu, 22 Aug 2013 08:11:09 GMT

Solved as:

Segment 1 <0

Segment 2 0

Segment 3 0.001

topic Traffic lights settings in QlikView

Traffic lights settings

Re: Traffic lights settings