Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
dafnis14
Specialist
Specialist

How to calculate the largest class value

Hi,

I would like to display dynamically the largest class value of a calculated dimension based on Class and a slider,

in the Other label defined in the Dimension Limit tab.

Is there a way to do it?

Thanks!

2 Replies
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

If I understand your question correctly - yes, you should be able to do it if you copy/paste the same calculated dimension formula (which must be using the AGGR() function) and enclose it in a MAX() or a MaxString() function.

The only caveat is the alphabetic sorting of the result of the Class - the string 100 will be preceding the string 90. You may have to extract the numeric value of the lower (or higher) end of the range and force it into a numeric format in order to get a reliable maximum...

dafnis14
Specialist
Specialist
Author

Hi Oleg,

Thank you for your prompt reply.

Since I needed the first 5 values, I had to apply the Min function.

Also, i added the above expression as the first table expression (hidden), in order to apply the desired dimension limit.

thanks!