topic Re: Gauge Chart Min/Max Setting in QlikView

Gauge Chart Min/Max Setting

asmithids — Wed, 12 Feb 2014 22:35:24 GMT

Hello,

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,

Re: Gauge Chart Min/Max Setting

Wed, 12 Feb 2014 23:46:11 GMT

Hi Smith, Can you please post the sample qvw ?

Re: Gauge Chart Min/Max Setting

fkeuroglian — Wed, 12 Feb 2014 23:49:16 GMT

Example please!

Re: Gauge Chart Min/Max Setting

asmithids — Thu, 13 Feb 2014 10:36:40 GMT

Please see attached QVW.

Thank you!

Re: Gauge Chart Min/Max Setting

gaidamichal — Thu, 13 Feb 2014 10:50:10 GMT

Hi,

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.

Re: Gauge Chart Min/Max Setting

Thu, 13 Feb 2014 10:53:09 GMT

Hi Alec

it is because when you select year and date your min = max due to your aggr

so the gauge can't show anything

Chris

Re: Gauge Chart Min/Max Setting

asmithids — Thu, 13 Feb 2014 11:03:10 GMT

Hi Christian,

Thank you.

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.

Re: Gauge Chart Min/Max Setting

Thu, 13 Feb 2014 11:16:01 GMT

Alec

=GetSelectedCount(Month) will give you the count

Chris

Re: Gauge Chart Min/Max Setting

asmithids — Thu, 13 Feb 2014 11:26:53 GMT

Works great! Thank you!

Re: Re: Gauge Chart Min/Max Setting

Thu, 13 Feb 2014 11:35:03 GMT

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..

Re: Re: Gauge Chart Min/Max Setting

asmithids — Thu, 13 Feb 2014 11:57:53 GMT

Hi Adeel,

I agree with you. I added your suggested code.

Thank you,