topic Re: Maximum value for Y-axis in QlikView

Maximum value for Y-axis

peschu123 — Tue, 18 Mar 2014 08:14:07 GMT

Hi community,

I use the following expression in my chart:

Delivery_relevant_date - only({<[Bezeichnung DLZ]={'Assessment'}>}[Start Vorgang])

Now I would like to set the maximum to 500. But if max value is for example is only 100 it should scale to 100.

I tried several possibilities in the chart properties for static max...but I don't get it to work

I appreciate any help.

Best Regards,

Peter

Re: Maximum value for Y-axis

jagan — Tue, 18 Mar 2014 08:22:12 GMT

Hi,

In chart properties -> Axes -> Scale-> Static Max

Give your expression - Max(MeasureName)

Regards,

jagan.

Re: Maximum value for Y-axis

peschu123 — Tue, 18 Mar 2014 08:31:48 GMT

Hi jagan,

thank you for your reply.

I dont get what you mean with Max(MeasureName) ?

I want something like the following

IF Delivery_relevant_date - only({<[Bezeichnung DLZ]={'Assessment'}>}[Start Vorgang])) > 500 than 500 else

Delivery_relevant_date - only({<[Bezeichnung DLZ]={'Assessment'}>}[Start Vorgang])

Re: Maximum value for Y-axis

jagan — Tue, 18 Mar 2014 08:39:40 GMT

Hi,

Give this expression in

In chart properties -> Axes -> Scale-> Static Max

If(only({<[Bezeichnung DLZ]={'Assessment'}>}[Start Vorgang]) > 500, 500,

only({<[Bezeichnung DLZ]={'Assessment'}>}[Start Vorgang]))

Regards,

Jagan.

Re: Maximum value for Y-axis

stevedark — Tue, 18 Mar 2014 08:46:27 GMT

Typically you will need an Aggr statement for doing this. To build on Jagan's expression:

=If(max(aggr(Delivery_relevant_date - only({<[Bezeichnung DLZ]={'Assessment'}>}[Start Vorgang]), [Your Dimensions])) > 500, 500,

max(aggr(Delivery_relevant_date - only({<[Bezeichnung DLZ]={'Assessment'}>}[Start Vorgang]), [Your Dimensions])) * 1.1)

The multiply by 1.1 is to allow a bit of space above the max point - or it can look like the line is off the top of the scale. You can adjust that number to suit.

If you search for AGGR you will find lots of information on the Community and elsewhere on line.

Hope that helps,

Steve

Re: Maximum value for Y-axis

peschu123 — Tue, 18 Mar 2014 08:48:44 GMT

Sorry this didn't work,

I calculate the difference between 2 dates, so the formula gives as result number of days for each order.

X-Axis = Orders

And in my chart I have 2-3 exceptions which have 1000 days as result, which destroys my axis scale...

Or in other Words, I want to ignore values higher than 500 for scaling my chart...

Re: Maximum value for Y-axis

ThornOfCrowns — Tue, 18 Mar 2014 08:56:40 GMT

You will always hit that problem if your average data is < 50 with a few outliers of 1000, i.e. 20 times greater. You could use a log scale, but you'd have to be clear in showing that you're doing so.