Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Channa
Valued Contributor III

Ranking

i am showing top 30 countries by using below expression in GEO map

 

=If(Aggr(Rank(Sum(CUSTOMS_VALUE_QAR)),COUNTRY_NAME_EN)<=30,COUNTRY_NAME_EN)

 

measure :sum(sales)

I have second chart by Product wise Sum(sales)

 

in that second chart i want to show only sales for top 30 countries

any advice

Channa
Labels (1)
1 Solution

Accepted Solutions

Re: Ranking

May be try this

Sum({<COUNTRY_NAME_EN = {"=Rank(Sum(CUSTOMS_VALUE_QAR)) <= 30"}>}CUSTOMS_VALUE_QAR)
3 Replies
Channa
Valued Contributor III

Re: Ranking

=If(Aggr(Rank(Sum(CUSTOMS_VALUE_QAR)),COUNTRY_NAME_EN)<=30,sum(CUSTOMS_VALUE_QAR))

 

i tried this expression but dosent work

Channa

Re: Ranking

May be try this

Sum({<COUNTRY_NAME_EN = {"=Rank(Sum(CUSTOMS_VALUE_QAR)) <= 30"}>}CUSTOMS_VALUE_QAR)
Channa
Valued Contributor III

Re: Ranking

Perfect bro thank you

Channa