Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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])
May be try this:
=If(Aggr(Rank(Sum([CC TCV KE])), [CC TCV KE], Country)<=15, [Sales Div Level 1])