topic Re: Default Static Max in QlikView

Default Static Max

NickHoff — Tue, 17 Nov 2015 18:31:21 GMT

How is the default static max of a chart calculated? I'm attempting to do a conditional on the static max, I have my conditional working but i'm unable to get the default max the chart displays based on the current expression.

Re: Default Static Max

sunny_talwar — Tue, 17 Nov 2015 18:39:30 GMT

Not sure what you mean by default static max? Can you elaborate a little?

Re: Default Static Max

NickHoff — Tue, 17 Nov 2015 18:43:56 GMT

When I plug in the following expression, the chart sizes based on the current set of data in that expression.

=NUM(SUM({$<CalendarYear =, CalendarMonthName =, Program -= {'Prevention'},AddedOn={">=$(=addmonths(max(Today()),-12)) <=$(=monthend(max(Today()),-1))"}>}CardiologistscheduledNN),'##')

What I want is the chart to scale differently using static max in the if a condition is met which I can get to work, but if that condition is not met I want the chart to size to the default state. However, I can't get the default state without knowing how Qlikview calculates the scale of a chart.

Re: Default Static Max

sunny_talwar — Tue, 17 Nov 2015 18:55:56 GMT

What if you create two charts and make them conditionally hide and show them?

Re: Default Static Max

rwunderlich — Tue, 17 Nov 2015 19:03:02 GMT

If you set the Static Max to null, QV will use it's own default. So use an if() and omit the 3rd parameter.

=if(my test condition, myscale)

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: Default Static Max

NickHoff — Tue, 17 Nov 2015 19:03:56 GMT

That won't work for what i'm doing sunny. I'm doing the above to always show a reference line on a chart if it's outside of the data range. If I correct the ones the reference line doesn't display correctly on, then the scale from the current data is thrown off.

Re: Default Static Max

sunny_talwar — Tue, 17 Nov 2015 19:04:07 GMT

Did not know that

Thanks for the information Rob

Re: Default Static Max

NickHoff — Tue, 17 Nov 2015 20:53:28 GMT

Thank you Rob that helped me out tremendously, great to know.

Re: Default Static Max

Tue, 19 Jan 2016 21:25:17 GMT

Do uhave a sample app for this

Re: Default Static Max

rwunderlich — Tue, 19 Jan 2016 23:33:18 GMT

Here is a sample app. I'm not sure what the real use case may be, but this app demonstrates the conditional setting of Static Max.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com