https://community.qlik.com/t5/QlikView/Ranking/m-p/1535944#M746808 <P>May be try this</P><PRE>Sum({&lt;COUNTRY_NAME_EN = {"=Rank(Sum(CUSTOMS_VALUE_QAR)) &lt;= 30"}&gt;}CUSTOMS_VALUE_QAR)</PRE> Mon, 28 Jan 2019 13:31:46 GMT sunny_talwar 2019-01-28T13:31:46Z https://community.qlik.com/t5/QlikView/Ranking/m-p/1535520#M746806 <P>i am showing top 30 countries by using below expression in GEO map</P><P>&nbsp;</P><P>=If(Aggr(Rank(Sum(CUSTOMS_VALUE_QAR)),COUNTRY_NAME_EN)&lt;=30,COUNTRY_NAME_EN)</P><P>&nbsp;</P><P>measure :sum(sales)</P><P>I have second chart by Product wise Sum(sales)</P><P>&nbsp;</P><P>in that second chart i want to show only sales for top 30 countries</P><P>any advice</P> Sat, 16 Nov 2024 21:31:49 GMT https://community.qlik.com/t5/QlikView/Ranking/m-p/1535520#M746806 Channa 2024-11-16T21:31:49Z https://community.qlik.com/t5/QlikView/Ranking/m-p/1535521#M746807 <P>=If(Aggr(Rank(Sum(CUSTOMS_VALUE_QAR)),COUNTRY_NAME_EN)&lt;=30,sum(CUSTOMS_VALUE_QAR))</P><P>&nbsp;</P><P>i tried this expression but dosent work</P> Sun, 27 Jan 2019 07:57:43 GMT https://community.qlik.com/t5/QlikView/Ranking/m-p/1535521#M746807 Channa 2019-01-27T07:57:43Z https://community.qlik.com/t5/QlikView/Ranking/m-p/1535944#M746808 <P>May be try this</P><PRE>Sum({&lt;COUNTRY_NAME_EN = {"=Rank(Sum(CUSTOMS_VALUE_QAR)) &lt;= 30"}&gt;}CUSTOMS_VALUE_QAR)</PRE> Mon, 28 Jan 2019 13:31:46 GMT https://community.qlik.com/t5/QlikView/Ranking/m-p/1535944#M746808 sunny_talwar 2019-01-28T13:31:46Z https://community.qlik.com/t5/QlikView/Ranking/m-p/1536110#M746809 <P>Perfect bro thank you</P> Mon, 28 Jan 2019 17:23:48 GMT https://community.qlik.com/t5/QlikView/Ranking/m-p/1536110#M746809 Channa 2019-01-28T17:23:48Z