Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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