topic Re: Dynamic Y-axis in QlikView

Dynamic Y-axis

patricwessels — Wed, 25 Nov 2020 16:16:04 GMT

I would like to set a dynamic Y-axis with the Max function. I know it works but now I can not use a field in this function (error message is " Incorrect fieldname"). Is this because it is a calculated field?

Re: Dynamic Y-axis

chrismarlow — Wed, 07 Nov 2018 16:38:36 GMT

Patric,

There are definitely limitations as to where you can use the names you have given your expressions, there was a thread a couple of weeks ago on something similar, so I think your conclusion is correct.

If you copy in the original expression will that work? You may need to wrap an aggr round it (referencing the relevant dimensions) to get the right value.

Regards,

Chris.

Re: Dynamic Y-axis

patricwessels — Thu, 08 Nov 2018 09:25:44 GMT

Chris,

Thanks for your reply.

I have defined the following: Afkeur MD = sum(If([Produktbreedte]<1330,([lengte rol]-[netto lengte])*0.62,([lengte rol]-[netto lengte])*1.24)) (sorry for the dutch words)

This results in a sum of the square meters rejected material.

The max Y-axis I want defined as the max of these square meters.

I have this: Max(sum(If([Produktbreedte]<1330,([lengte rol]-[netto lengte])*0.62,([lengte rol]-[netto lengte])*1.24)))

but that doesn't work (error in expression)

If I need aggr how do I do that? Or is something else wrong?

Regards, Patric

Re: Dynamic Y-axis

chrismarlow — Thu, 08 Nov 2018 09:44:12 GMT

Hi Patric,

Yes, try aggr;

Max(aggr(sum(If([Produktbreedte]<1330,([lengte rol]-[netto lengte])*0.62,([lengte rol]-[netto lengte])*1.24)), dimension ))

I've tried to bold the bits to insert, dimension would be the dimension your chart uses, comma separated list if more than one.

Let me know how you get on.

Regards,

Chris.

Re: Dynamic Y-axis

patricwessels — Thu, 08 Nov 2018 10:12:39 GMT

Works great, thanks.

I 'forgot' the dimension in the aggr function,

Regards, Patric