Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Top 15 sales

Hi -

I am trying to write an expression where in a bar chart i am only displaying top 15 Sales by region and sales people.

I tried ranking but i cant get the formula to work.

Dim 1 - Region

Dim 2 - Sales Person

Measure - Sales

Please help

Thank you!

13 Replies
pedromsouza
Creator
Creator

You can use the "Dimension Limits" tab on chart's properties.

Qliking since '09
Not applicable
Author

I dont see that option, where would i find it?

pedromsouza
Creator
Creator

Upgrade to Qlikview Desktop 11.

Qliking since '09
Not applicable
Author

Is there way to do this without an upgrade?

montero91
Creator
Creator

In chart properties, go to the tab presentation incorporates a limit on the size, but  disables of the scroll

chematos
Specialist II
Specialist II

if(rank(aggr(sum(Sales), Region, [Sales Person]))<=15,

aggr(sum(Sales), Region, [Sales Person]))

Not applicable
Author

This worked!

By any chance would you know how i can filter this expression to only display two regions and rank sales in order (Highest to lowest)?

thank you

chematos
Specialist II
Specialist II

if(rank(aggr(sum({<Region = {'Region1','Region2'}>} Sales), Region, [Sales Person]))<=15,

aggr(sum({<Region = {'Region1','Region2'}>} Sales), Region, [Sales Person]))

You can configure orders in Order Sheet of object properties.

Could you mark the answer to close this discussion, please?

Thank you,

Regards.

Not applicable
Author

For some reason this formula does not work for me.

What would the best way to filter on the two reions? Create a separate dimension?