topic Top-n values on 2nd Dimension v11 in QlikView

Top-n values on 2nd Dimension v11

rbecher — Fri, 18 May 2012 18:15:20 GMT

Hi,

in the new version 11 we got the new Dimension Limits tab in Chart properties. The old way on version 10 "Max Visible Number (1-100)" in Presentation tab is gone! So, how to only display the overall Top-5 of the 2nd Dimension in version 11?

To give an example what is not possible anymore:

Version 10 - works great, only the Top-5 Locations are shown:

Version 11 - the Top-5 on every bar (on every Dimension 1 value) are shown, not what I expected:

Any suggestion how to build this on version 11?

- Ralf

Top-n values on 2nd Dimension v11

Anonymous — Fri, 18 May 2012 19:56:28 GMT

Hi Ralf!

Did you try the Global Grouping Mode? This takes your dimensions as a whole and limits to the top 5. Not sure if it will solve your issue, but worth a shot.

Thanks,

Aaron

Top-n values on 2nd Dimension v11

rbecher — Fri, 18 May 2012 20:53:47 GMT

Hi Aaron,

thanks, that easy! This should be checked per default if you open a QV10 app in QV11 with dimension limits..

- Ralf