topic Re: Max value for list box expression in QlikView

Max value for list box expression

Thu, 06 Sep 2012 18:47:57 GMT

I have a fairly simple expression I need. I'm new at this so it may be easy for some.

I need to generate the Max value for the Linear gauge shown below based on 9 items each.

See below for Clarity. Right now I typed in the max but that is only to prove to myself it will work. So 214 is the Max value Im trying to derive here.

Right now I have: =Rangemax((Count(TopLevelWBS))) = 703 the Sum Total not Max value from the count

Re: Max value for list box expression

Anonymous — Thu, 06 Sep 2012 19:25:32 GMT

Brian,

I assume it is a list box with expression. Try this:
max(aggr(Count(TopLevelWBS), TopLevelWBS)) * 1.05

Regards,
Michael

Re: Max value for list box expression

Thu, 06 Sep 2012 20:16:52 GMT

I tried this variation which outputted 214 Exactly! Didn't need the 1.05 or 1.0 maybe it was to create a buffer/padding?

Thank You so much.

=max(aggr(Count(TopLevelWBS), TopLevelWBS))

Re: Max value for list box expression

Anonymous — Thu, 06 Sep 2012 20:21:53 GMT

Technically you don't need 1.05 - it is just for a little better look, leaves some space on the right.

Re: Max value for list box expression

Thu, 06 Sep 2012 20:23:46 GMT

ah, ok that's what I was thinking after I thought about it, adds a little padding to the right, makes sense. I will do that then.

Re: Max value for list box expression

Fri, 07 Sep 2012 13:25:27 GMT

How do I maintain that Max value even if I select values that are smaller? If I hard code it the gauge stays in proper ratio. I tried this but doesn't quite do it. I was able to keep the values for one column in place but the Max gets skewed to the selection vs the true max value.

=max(aggr(Count({1}TopLevelWBS),TopLevelWBS)) *1.05

Re: Max value for list box expression

Fri, 07 Sep 2012 14:24:44 GMT

Ok, I figured it out I have to add the TOTAL.

=max({1} TOTAL aggr(Count({1}TopLevelWBS),TopLevelWBS)) *1.05

Re: Max value for list box expression

Tue, 30 Sep 2014 19:53:49 GMT

thanks.. helped in my case!