topic Re: Display top 5 countries in App Development

Display top 5 countries

niranjana — Wed, 19 May 2021 09:24:51 GMT

I have a requirement where i have to display top 5 countries with maximum sales in qliksense text box. Not sales, but top 5 countries with sales. Is it possible using aggregate function in a single line?

Thanks in advance

Re: Display top 5 countries

MayilVahanan — Wed, 19 May 2021 10:45:17 GMT

Hi @niranjana

Try like below

=Concat(Aggr(If(Rank(Sum(Sales))<= 5, Country&'('&Sum(Sales)&')'), Country), ',', Aggr(Rank(Sum(Sales)), Country))

It will display Country & Sales with highest rank to lowest rank

Re: Display top 5 countries

niranjana — Thu, 20 May 2021 10:47:41 GMT

Thanks a lot...it is working ..what if i want to show from 2nd like 2nd to 5th rank..excluding the first topmost country?

Re: Display top 5 countries

MayilVahanan — Thu, 20 May 2021 15:58:37 GMT

Hi @niranjana

In that case, change the if condition

=Concat(Aggr(If(Rank(Sum(Sales))>1 and Rank(Sum(Sales)) <=5, Country&'('&Sum(Sales)&')'), Country), ',', Aggr(Rank(Sum(Sales)), Country))