top n on bar chart

[salezian]

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.

[Anonymous]

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.

[#3]

You have this option under chart properties->dimension Limits.

is that what your after?

[Luis_Cortizo]

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