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: 
Not applicable

need to get Top 15 deals from below pivot table for all countries (sales div level1)

Hi all please help me to get Top 15 deals for pivot table which i have created in qlikview currently it is giving me only top 15 for single country if i select multiple countries it will adjust it self and give me total top 15 deals from over all data.

what i need is i want to get Top 15 deals for each country whenever i select all countries it should give top 15 for all countries

my formula is =if(aggr(rank(sum([CC TCV KE])),[CC TCV KE])<=15,[Sales Div Level 1])

Top 15 deals.png

1 Reply
sunny_talwar

May be try this:

=If(Aggr(Rank(Sum([CC TCV KE])), [CC TCV KE], Country)<=15, [Sales Div Level 1])