Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Max of three expressions in area chart for max static axis

Hi!

I have an area chart with one dimensión (ID), and three expressions (GRT, AIT, AIS), and I would like to set the max value for the Y axis as the max value of the three expressions. For this, I've tried to set in the field Max Static of the three dimensions (in Axis tab) something like this:

= if(max(GRT,AIT) = GRT, max(GRT,AIS), max(AIT, AIS))

I thought that these expression would work, but it doesn't work...

Thanks in advance!

1 Reply
sunny_talwar

May be try RangeMax()

RangeMax(GRT, AIT, AIS)