
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Ranking top 10
Hi,
I would like to only include the top 10 items in sales. Here is by Retail Sales expression below, with an image of the fields I am using in my table
Sum({<[Week Ending]={'$(=Max([Week Ending]))'}>}[Retail Sales])
Is there a place in the expression where I can add a Rank formula?
Thank you!


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I have, but there's no option in the dropdown. It also is not working correctly when I do set a limitation to Retailer SKU
Retailer SKU limitation setting


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You can't set a limit on the measure, only the dimension. What do you mean when you say you tried applying the limit but it didn't work? What didn't work?
If you could supply an Excel sheet with some representative data, it would be easier to advise.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Alternarively, have you tried using the aggr() function as in this post in order to specify over which dimensions the measure should be ranked?: https://community.qlik.com/t5/QlikView-App-Dev/Rank-within-a-specific-dimension-when-you-have-multip...

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Here is a screen shot-Limitation is set, and is still showing more than the top 10 sales.
