Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

MCampestrini
Valued Contributor

How to get the max value of an axis?

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!

Márcio Rodrigo Campestrini
1 Solution

Accepted Solutions
MCampestrini
Valued Contributor

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

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

Márcio Rodrigo Campestrini
5 Replies
MVP
MVP

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

May be simply like: =max(YourDimensionInAxis)

MCampestrini
Valued Contributor

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

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.

Sem título.png

Márcio Rodrigo Campestrini
Not applicable

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

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

MCampestrini
Valued Contributor

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

Rishi, it doesn't seems to work.

Márcio Rodrigo Campestrini
MCampestrini
Valued Contributor

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

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

Márcio Rodrigo Campestrini
Community Browser