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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Qlik1_User1
Specialist
Specialist

TOP 10 countries based on particular year

Hi All,

Please help with below query,

in bar chart i need to show top 10 counties, which will compare sales  of selected year (2019) and selected year-1(2018)
But top 10 countries will be based on sales of selected year(2019) and accordingly previous year data will compared based on those countries.

 

 

Labels (4)
2 Replies
vinieme12
Champion III
Champion III

Something like below

=sum(aggr(if(rank(sum(Sales),1,1)<=10,sum(Sales)),Year,Country))
Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Qlik1_User1
Specialist
Specialist
Author

Thanks @vinieme12 will check this.
Can you please help on below question
https://community.qlik.com/t5/New-to-Qlik-Sense/Map-Object/td-p/1940138