Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
KPage
Contributor III
Contributor III

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])

KPage_0-1693492027273.png

 

Is there a place in the expression where I can add a Rank formula?

Thank you!

Labels (3)
5 Replies
rbartley
Specialist II
Specialist II

Hi @KPage ,

Have you tried setting a Fixed number limitation on the dimension(s)?

 

rbartley_0-1693492568045.png

 

 

KPage
Contributor III
Contributor III
Author

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

KPage_0-1693492670049.png

Retailer SKU limitation setting

KPage_1-1693492745066.png

 

 

rbartley
Specialist II
Specialist II

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.

 

rbartley
Specialist II
Specialist II

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...

 

KPage
Contributor III
Contributor III
Author

Here is a screen shot-Limitation is set, and is still showing more than the top 10 sales. 

KPage_0-1693494032108.png