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: 
salezian
Creator
Creator

top n on bar chart

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.

3 Replies
Anonymous
Not applicable

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.

Not applicable

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

is that what your after?

Luis_Cortizo
Former Employee
Former Employee

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