topic rank and Order by in QlikView https://community.qlik.com/t5/QlikView/rank-and-Order-by/m-p/172805#M42234 <HTML><HEAD></HEAD><BODY><P>Hello,every body here:</P><P>I used a pivot table to get a display like my attached jpg chart.</P><P>NO.N means in the period of time (may be thisweek or lastweek),each company (may be COMP.A,COMP.B,COMP.C) ordered by their sales volumn descend</P><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-1724_sourceID:1724" /></P><P>I used aggr(rank()) as my dimension ,but it still didn't work.</P><P>Can anybody help me ?</P></BODY></HTML> Wed, 02 Jun 2010 07:43:43 GMT 2010-06-02T07:43:43Z rank and Order by https://community.qlik.com/t5/QlikView/rank-and-Order-by/m-p/172805#M42234 <HTML><HEAD></HEAD><BODY><P>Hello,every body here:</P><P>I used a pivot table to get a display like my attached jpg chart.</P><P>NO.N means in the period of time (may be thisweek or lastweek),each company (may be COMP.A,COMP.B,COMP.C) ordered by their sales volumn descend</P><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-1724_sourceID:1724" /></P><P>I used aggr(rank()) as my dimension ,but it still didn't work.</P><P>Can anybody help me ?</P></BODY></HTML> Wed, 02 Jun 2010 07:43:43 GMT https://community.qlik.com/t5/QlikView/rank-and-Order-by/m-p/172805#M42234 2010-06-02T07:43:43Z