Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER 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])