Discussion Board for collaboration on QlikView Scripting.
I created a gauge that computes the average number of orders(i.e. References) per month using the following calculation.
=Avg(Aggr(Count (Reference),Year, Month))
On the Presentation tab, I set the following Gauge settings:
Min(Aggr(Count(Reference), Year, Month))
Max(Aggr(Count(Reference), Year, Month))
The issue is that when I select one month from my Month list box, I get an error of "Bad Min or Max Value in Gauge". See attached screen shot. When I select more than one month, the gauge computes the Min and Max without error. See second screen shot.
Any information to resolve this issue would be much appreciated. Thank you,
Solved! Go to Solution.
the reason that the max and min values are giving an error is because when you select one month, the max and min values are equal and the object cannot display te gauge. You need to make sure that the values are different.
Question, is there a function to count the number of months selected in the Month list box? I'm thinking of adding an if statement to the Min setting like this:
if ("months selected" >1, Min(Aggr(Count(Reference), Year, Month)), 0)
By having a Min of 0 when one month is selected, I get the gauge to display a Min of 0 through the Max value.
Alec dont you think that if you done this it will always shows your avg order in red side which is something wrong in my point of view
you can use like attached..