topic Re: How to get the max value of an axis? in QlikView

How to get the max value of an axis?

Marcio_Campestrini — Tue, 24 Jun 2014 12:39:13 GMT

Hi everybody!

I have an issue. Ther's an application with a graph that have two expressions, one on each axis. I received a request that the maximum value of the right axis should be proportional to the maximum value of the left axis. So I ask, there's a way to get this value and use it in a formula?

Thanks in advance!

Re: How to get the max value of an axis?

tresB — Tue, 24 Jun 2014 12:41:54 GMT

May be simply like: =max(YourDimensionInAxis)

Re: How to get the max value of an axis?

Marcio_Campestrini — Tue, 24 Jun 2014 13:17:57 GMT

Tresesco.

Thansk for the answer, but I didn't got what you mean with YourDimensionInAxis? Is it the expression name?

If it helps, I want the value 110, in the image below.

Re: How to get the max value of an axis?

Tue, 24 Jun 2014 13:21:50 GMT

Or you can use the Max(Column) {Where column : It will have the value coming from the expression}

Re: How to get the max value of an axis?

Marcio_Campestrini — Tue, 24 Jun 2014 13:27:28 GMT

Rishi, it doesn't seems to work.

Re: How to get the max value of an axis?

Marcio_Campestrini — Tue, 24 Jun 2014 13:46:25 GMT

Hello.

I use the following formula and it worked.

=(max(aggr(count(DISTINCT <first axis expression>), <field_name>)) * 1.20) / 10

With this, I made the second x-axis proportional to the first.

Thanks