https://community.qlik.com/t5/QlikView/Nested-set-analysis/m-p/1521241#M747864 <P>May be this</P><PRE>Sum({1&lt;Genero = {"*Horror*"}, Pais = {"=Rank(Sum({1&lt;Genero = {[*Horror*]}&gt;} Sales), 1, 1)) &lt;= 20"}&gt;} Sales)</PRE> Fri, 14 Dec 2018 20:55:01 GMT sunny_talwar 2018-12-14T20:55:01Z https://community.qlik.com/t5/QlikView/Nested-set-analysis/m-p/1521239#M747863 <P><span class="lia-inline-image-display-wrapper lia-image-align-right" image-alt="nested.PNG" style="width: 769px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/2248i0820F151EA767D4B/image-size/large?v=v2&amp;px=999" role="button" title="nested.PNG" alt="nested.PNG" /></span>I want to show the sales from the 20 first countries which sale horror movies, but I don't know how to anidate&nbsp;the function&nbsp;with set analysis&nbsp;to the set analysis.&nbsp;</P><P>Sum({1&lt;Genero={"*Horror*"},Pais={"$(=rank(sum({1&lt;Genero={"*Horror*"}&gt;}Sales),1,1))&lt;=20"}&gt;}Sales)</P><P>i though with the dollar-sign expansion, but still doesn't works.&nbsp;</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Nested-set-analysis/m-p/1521239#M747863 giovannarugerio 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Nested-set-analysis/m-p/1521241#M747864 <P>May be this</P><PRE>Sum({1&lt;Genero = {"*Horror*"}, Pais = {"=Rank(Sum({1&lt;Genero = {[*Horror*]}&gt;} Sales), 1, 1)) &lt;= 20"}&gt;} Sales)</PRE> Fri, 14 Dec 2018 20:55:01 GMT https://community.qlik.com/t5/QlikView/Nested-set-analysis/m-p/1521241#M747864 sunny_talwar 2018-12-14T20:55:01Z