topic Re: How to calculate the largest class value in QlikView

How to calculate the largest class value

dafnis14 — Thu, 04 Jun 2015 16:03:12 GMT

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!

Re: How to calculate the largest class value

Oleg_Troyansky — Thu, 04 Jun 2015 16:10:48 GMT

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...

Re: How to calculate the largest class value

dafnis14 — Thu, 04 Jun 2015 17:19:38 GMT

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!