topic Top 5 in QlikView https://community.qlik.com/t5/QlikView/Top-5/m-p/213923#M67545 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I am using the expresssion</P><P style="margin: 0in 0in 0pt; line-height: normal; mso-layout-grid-align: none;">=Count(If(Rank(Count(IF((FROM_TIME&gt;=(MakeDate(Year(Today()-7),Month(Today()-7),Day(Today()-7))) and (FROM_TIME&lt;=(MakeDate(Year(Today()-1),Month(Today()-1),Day(Today()-1))))),ID_) ),4,2)&lt;=5,ID))</P><P>to display the top 5. But it is not displaying any values.</P><P></P><BR /><BR /></BODY></HTML> Sun, 13 Feb 2011 07:03:17 GMT 2011-02-13T07:03:17Z Top 5 https://community.qlik.com/t5/QlikView/Top-5/m-p/213923#M67545 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I am using the expresssion</P><P style="margin: 0in 0in 0pt; line-height: normal; mso-layout-grid-align: none;">=Count(If(Rank(Count(IF((FROM_TIME&gt;=(MakeDate(Year(Today()-7),Month(Today()-7),Day(Today()-7))) and (FROM_TIME&lt;=(MakeDate(Year(Today()-1),Month(Today()-1),Day(Today()-1))))),ID_) ),4,2)&lt;=5,ID))</P><P>to display the top 5. But it is not displaying any values.</P><P></P><BR /><BR /></BODY></HTML> Sun, 13 Feb 2011 07:03:17 GMT https://community.qlik.com/t5/QlikView/Top-5/m-p/213923#M67545 2011-02-13T07:03:17Z Top 5 https://community.qlik.com/t5/QlikView/Top-5/m-p/213924#M67546 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I got the solution from the post</P><P><A href="http://community.qlik.com/forums/p/39906/157392.aspx#157392">http://community.qlik.com/forums/p/39906/157392.aspx#157392</A></P><P></P></BODY></HTML> Sun, 13 Feb 2011 07:38:13 GMT https://community.qlik.com/t5/QlikView/Top-5/m-p/213924#M67546 2011-02-13T07:38:13Z