Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Report on items that are ranked from 11th to 20th?

I know it is possible to report on top N items or bottom N items in a chart. However I want to report on 11th to 20th ranked items based on Sales value.

2 Replies
Not applicable
Author

Hi Mayuran,

Have'nt  tries this expression, guess this should be working:

aggr(if(Rank(total Sum(sales))>11,if(Rank(total Sum(sales))<=20 , Customer)), Customer)

tresesco
MVP
MVP

Try like:

=Sum({<ItemID={"=Rank(Sum(Sales))>10 and Rank(Sum(Sales))<21"}>}Sales)