Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone
Is it possible to display on bar chart top n values ?. There is parameter to set x displayed dimension but for it doesn't show top values.
Best regards.
Wrap the expression within a Ranked If statement for example IF(Rank(expression)<11,expression) this should give you top 10 numbers for example providing this is what you were after.
You have this option under chart properties->dimension Limits.
is that what your after?
The Dimension Limits are only available on QlikView 11.
In case you have a previous version you can always Sort the bar chart in the way you wish (e.g. with and Expression... Sum(Sales)) and then limit the number of values that the X axis is showing (under the Presentation Tab).
Don't forget to uncheck the X-Axis scrollbar