Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Marcio_Campestrini
Specialist
Specialist

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
Marcio_Campestrini
Specialist
Specialist
Author

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

View solution in original post

5 Replies
tresesco
MVP
MVP

May be simply like: =max(YourDimensionInAxis)

Marcio_Campestrini
Specialist
Specialist
Author

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

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

Marcio_Campestrini
Specialist
Specialist
Author

Rishi, it doesn't seems to work.

Márcio Rodrigo Campestrini
Marcio_Campestrini
Specialist
Specialist
Author

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