https://community.qlik.com/t5/QlikView/rank-expression/m-p/1793476#M1210912 <P>Hi everybody,</P><P>I need some help for a rank expression. I need to have a rank of my selected shop "D_ANNECY" for each field of my sector's hierarchy in my table.</P><P>Now I use this expression :</P><P>only({&lt;[Comparatif Magasin]={'$(vMagasin_Analyse)'}&gt;}Aggr(rank(Sum([CA HT k€ Maille])),[Comparatif Magasin]))</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Romain1_0-1616433409618.png" style="width: 684px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/51623iC2DE83A1224140A4/image-dimensions/684x245?v=v2" width="684" height="245" role="button" title="Romain1_0-1616433409618.png" alt="Romain1_0-1616433409618.png" /></span></P><P>It work's when I just select one value for each fields of my sector's hierarchy.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Romain1_1-1616433768987.png" style="width: 610px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/51624iC62F70300026E362/image-dimensions/610x215?v=v2" width="610" height="215" role="button" title="Romain1_1-1616433768987.png" alt="Romain1_1-1616433768987.png" /></span></P><P>When one of the fields are unselected, my expression doesn't work like I want. I don't know why.</P><P>I try this one (not good result) :&nbsp;only({&lt;[Comparatif Magasin]={'$(vMagasin_Analyse)'}&gt;}Aggr(rank(Sum([CA HT k€ Maille])),[Comparatif Magasin],Secteur,[Sous Secteur],Maille))&nbsp;</P><P>I need to have good results for my each rows of my column "RANK".</P><P>Could you give me some help ?</P><P>Sorry for my bad english.</P><P>Regards,</P><P>Romain</P><P>&nbsp;</P> Mon, 22 Mar 2021 17:34:25 GMT Romain1 2021-03-22T17:34:25Z https://community.qlik.com/t5/QlikView/rank-expression/m-p/1793476#M1210912 <P>Hi everybody,</P><P>I need some help for a rank expression. I need to have a rank of my selected shop "D_ANNECY" for each field of my sector's hierarchy in my table.</P><P>Now I use this expression :</P><P>only({&lt;[Comparatif Magasin]={'$(vMagasin_Analyse)'}&gt;}Aggr(rank(Sum([CA HT k€ Maille])),[Comparatif Magasin]))</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Romain1_0-1616433409618.png" style="width: 684px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/51623iC2DE83A1224140A4/image-dimensions/684x245?v=v2" width="684" height="245" role="button" title="Romain1_0-1616433409618.png" alt="Romain1_0-1616433409618.png" /></span></P><P>It work's when I just select one value for each fields of my sector's hierarchy.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Romain1_1-1616433768987.png" style="width: 610px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/51624iC62F70300026E362/image-dimensions/610x215?v=v2" width="610" height="215" role="button" title="Romain1_1-1616433768987.png" alt="Romain1_1-1616433768987.png" /></span></P><P>When one of the fields are unselected, my expression doesn't work like I want. I don't know why.</P><P>I try this one (not good result) :&nbsp;only({&lt;[Comparatif Magasin]={'$(vMagasin_Analyse)'}&gt;}Aggr(rank(Sum([CA HT k€ Maille])),[Comparatif Magasin],Secteur,[Sous Secteur],Maille))&nbsp;</P><P>I need to have good results for my each rows of my column "RANK".</P><P>Could you give me some help ?</P><P>Sorry for my bad english.</P><P>Regards,</P><P>Romain</P><P>&nbsp;</P> Mon, 22 Mar 2021 17:34:25 GMT https://community.qlik.com/t5/QlikView/rank-expression/m-p/1793476#M1210912 Romain1 2021-03-22T17:34:25Z