topic Re: How to give Date wise Rank in QlikView https://community.qlik.com/t5/QlikView/How-to-give-Date-wise-Rank/m-p/1387791#M422354 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P>try this :</P><P></P><P><SPAN style="font-size: 9.0pt; font-family: 'Arial',sans-serif; color: blue;">RANK</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial',sans-serif; color: black;">(</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial',sans-serif; color: blue;">ONLY</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial',sans-serif; color: black;">({1} <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">meeting id</SPAN></SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial',sans-serif; color: black;">))&nbsp;&nbsp; </SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Arial',sans-serif; color: black;"><BR /></SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Arial',sans-serif; color: black;"><BR /></SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Arial',sans-serif; color: black;">or</SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Arial',sans-serif; color: black;"><BR /></SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Arial',sans-serif; color: black;">do you have any field to be aggregated (numerical ) ?<BR /></SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Arial',sans-serif; color: black;"><BR /></SPAN></P></BODY></HTML> Tue, 12 Dec 2017 10:41:59 GMT Anonymous 2017-12-12T10:41:59Z How to give Date wise Rank https://community.qlik.com/t5/QlikView/How-to-give-Date-wise-Rank/m-p/1387790#M422353 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>I hvea meeting id, client name, Date dimension is there.</P><P>I need want to do date and client name and meetin id&nbsp; wise rank.</P><P><SPAN style="font-size: 10pt;">How it will get?</SPAN></P></BODY></HTML> Tue, 12 Dec 2017 10:37:43 GMT https://community.qlik.com/t5/QlikView/How-to-give-Date-wise-Rank/m-p/1387790#M422353 Anonymous 2017-12-12T10:37:43Z Re: How to give Date wise Rank https://community.qlik.com/t5/QlikView/How-to-give-Date-wise-Rank/m-p/1387791#M422354 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P>try this :</P><P></P><P><SPAN style="font-size: 9.0pt; font-family: 'Arial',sans-serif; color: blue;">RANK</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial',sans-serif; color: black;">(</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial',sans-serif; color: blue;">ONLY</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial',sans-serif; color: black;">({1} <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">meeting id</SPAN></SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial',sans-serif; color: black;">))&nbsp;&nbsp; </SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Arial',sans-serif; color: black;"><BR /></SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Arial',sans-serif; color: black;"><BR /></SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Arial',sans-serif; color: black;">or</SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Arial',sans-serif; color: black;"><BR /></SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Arial',sans-serif; color: black;">do you have any field to be aggregated (numerical ) ?<BR /></SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Arial',sans-serif; color: black;"><BR /></SPAN></P></BODY></HTML> Tue, 12 Dec 2017 10:41:59 GMT https://community.qlik.com/t5/QlikView/How-to-give-Date-wise-Rank/m-p/1387791#M422354 Anonymous 2017-12-12T10:41:59Z Re: How to give Date wise Rank https://community.qlik.com/t5/QlikView/How-to-give-Date-wise-Rank/m-p/1387792#M422355 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 9pt; font-family: Arial, sans-serif; color: blue;">aggr (RANK</SPAN><SPAN style="font-size: 9pt; font-family: Arial, sans-serif; color: black;">(</SPAN><SPAN style="color: #0000ff; font-size: 9pt; font-family: Arial, sans-serif;">count(</SPAN><SPAN style="color: #3d3d3d; font-size: 13px; font-style: inherit; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-weight: inherit;">meeting id</SPAN><SPAN style="font-size: 9pt; font-family: Arial, sans-serif; color: black;">)),date)&nbsp; </SPAN></P></BODY></HTML> Tue, 12 Dec 2017 10:47:50 GMT https://community.qlik.com/t5/QlikView/How-to-give-Date-wise-Rank/m-p/1387792#M422355 Anonymous 2017-12-12T10:47:50Z Re: How to give Date wise Rank https://community.qlik.com/t5/QlikView/How-to-give-Date-wise-Rank/m-p/1387793#M422356 <HTML><HEAD></HEAD><BODY><P>I have already meeting id count based on the client name.</P><P></P><P>And i am using the two calendar objects (Date range purpose).</P><P>When i give date range cmng the rank only in between.</P><P></P><P>How it will get in pivot table</P></BODY></HTML> Tue, 12 Dec 2017 11:01:01 GMT https://community.qlik.com/t5/QlikView/How-to-give-Date-wise-Rank/m-p/1387793#M422356 Anonymous 2017-12-12T11:01:01Z