topic Re: First Row of the Group in QlikView https://community.qlik.com/t5/QlikView/First-Row-of-the-Group/m-p/599381#M479457 <HTML><HEAD></HEAD><BODY><P>Hi, Please find attached an example of how to achieve this.</P><P></P><P>Thanks</P><P><A href="http://biexperience.wordpress.com/">JV</A></P></BODY></HTML> Mon, 03 Feb 2014 09:53:16 GMT jvitantonio 2014-02-03T09:53:16Z First Row of the Group https://community.qlik.com/t5/QlikView/First-Row-of-the-Group/m-p/599379#M479455 <HTML><HEAD></HEAD><BODY><P>Dear All</P><P></P><P>I have a data in below mentioned format.</P><P></P><P>I just want to to display on first row of each group.</P><P>First row of each group should be the row having least Mfg_Date of the group.</P><P></P><P>Grouping is based on Product ID.</P><P></P><P>Kindly suggest.</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 327px;"><TBODY><TR><TD class="xl65" height="20" width="71">Product ID</TD><TD class="xl65" style="border-left: none;" width="64">Name</TD><TD class="xl65" style="border-left: none;" width="64">Batch #</TD><TD class="xl65" style="border-left: none;" width="64">Mfg Date</TD><TD class="xl65" style="border-left: none;" width="64">Qty</TD></TR><TR><TD align="right" class="xl63" height="20" style="border-top: none;">1</TD><TD class="xl63" style="border-top: none; border-left: none;">ABC</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">123</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">1-Jan-14</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">232</TD></TR><TR><TD align="right" class="xl63" height="20" style="border-top: none;">1</TD><TD class="xl63" style="border-top: none; border-left: none;">ABC</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">456</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">10-Jan-14</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">433</TD></TR><TR><TD align="right" class="xl63" height="20" style="border-top: none;">1</TD><TD class="xl63" style="border-top: none; border-left: none;">ABC</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">234</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">15-Jan-14</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">54</TD></TR><TR><TD align="right" class="xl63" height="20" style="border-top: none;">2</TD><TD class="xl63" style="border-top: none; border-left: none;">XYZ</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">34</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">2-Jan-14</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">76</TD></TR><TR><TD align="right" class="xl63" height="20" style="border-top: none;">2</TD><TD class="xl63" style="border-top: none; border-left: none;">XYZ</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">432</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">5-Jan-14</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">54</TD></TR><TR><TD align="right" class="xl63" height="20" style="border-top: none;">2</TD><TD class="xl63" style="border-top: none; border-left: none;">XYZ</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">4354</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">31-Jan-14</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">545</TD></TR><TR><TD align="right" class="xl63" height="20" style="border-top: none;">2</TD><TD class="xl63" style="border-top: none; border-left: none;">XYZ</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">4534</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">1-Feb-14</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">544</TD></TR><TR><TD align="right" class="xl63" height="20" style="border-top: none;">3</TD><TD class="xl63" style="border-top: none; border-left: none;">QWE</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">4234</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">10-Jan-14</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">454</TD></TR><TR><TD align="right" class="xl63" height="20" style="border-top: none;">3</TD><TD class="xl63" style="border-top: none; border-left: none;">QWE</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">6456</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">25-Jan-14</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">657</TD></TR><TR><TD align="right" class="xl63" height="20" style="border-top: none;">4</TD><TD class="xl63" style="border-top: none; border-left: none;">ASD</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">867</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">11-Jan-14</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">54</TD></TR><TR><TD align="right" class="xl63" height="20" style="border-top: none;">4</TD><TD class="xl63" style="border-top: none; border-left: none;">ASD</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">54</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">12-Jan-14</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">5453</TD></TR><TR><TD align="right" class="xl63" height="20" style="border-top: none;">4</TD><TD class="xl63" style="border-top: none; border-left: none;">ASD</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">534</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">25-Jan-14</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">342</TD></TR><TR><TD align="right" class="xl63" height="20" style="border-top: none;">4</TD><TD class="xl63" style="border-top: none; border-left: none;">ASD</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">654</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">29-Jan-14</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">323</TD></TR><TR><TD align="right" class="xl63" height="20" style="border-top: none;">4</TD><TD class="xl63" style="border-top: none; border-left: none;">ASD</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">6456</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">2-Feb-14</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">342</TD></TR><TR><TD align="right" class="xl63" height="20" style="border-top: none;">5</TD><TD class="xl63" style="border-top: none; border-left: none;">ZXC</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">5345</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">5-Jan-14</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">534</TD></TR><TR><TD align="right" class="xl63" height="20" style="border-top: none;">5</TD><TD class="xl63" style="border-top: none; border-left: none;">ZXC</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">4234</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">10-Jan-14</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">4534</TD></TR><TR><TD align="right" class="xl63" height="20" style="border-top: none;">5</TD><TD class="xl63" style="border-top: none; border-left: none;">ZXC</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">432</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">15-Jan-14</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">534</TD></TR><TR><TD align="right" class="xl63" height="20" style="border-top: none;">5</TD><TD class="xl63" style="border-top: none; border-left: none;">ZXC</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">5454</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">16-Jan-14</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">2342</TD></TR><TR><TD align="right" class="xl63" height="20" style="border-top: none;">5</TD><TD class="xl63" style="border-top: none; border-left: none;">ZXC</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">6565</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">25-Jan-14</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">56</TD></TR><TR><TD align="right" class="xl63" height="20" style="border-top: none;">5</TD><TD class="xl63" style="border-top: none; border-left: none;">ZXC</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">87686</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">2-Feb-14</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">676</TD></TR></TBODY></TABLE><P></P><P>Thanks &amp; Regards</P><P>Aqeel Nawaz</P></BODY></HTML> Mon, 03 Feb 2014 09:06:30 GMT https://community.qlik.com/t5/QlikView/First-Row-of-the-Group/m-p/599379#M479455 2014-02-03T09:06:30Z Re: First Row of the Group https://community.qlik.com/t5/QlikView/First-Row-of-the-Group/m-p/599380#M479456 <HTML><HEAD></HEAD><BODY><P>Try using rank function and restrict the data using if condition.</P></BODY></HTML> Mon, 03 Feb 2014 09:15:24 GMT https://community.qlik.com/t5/QlikView/First-Row-of-the-Group/m-p/599380#M479456 2014-02-03T09:15:24Z Re: First Row of the Group https://community.qlik.com/t5/QlikView/First-Row-of-the-Group/m-p/599381#M479457 <HTML><HEAD></HEAD><BODY><P>Hi, Please find attached an example of how to achieve this.</P><P></P><P>Thanks</P><P><A href="http://biexperience.wordpress.com/">JV</A></P></BODY></HTML> Mon, 03 Feb 2014 09:53:16 GMT https://community.qlik.com/t5/QlikView/First-Row-of-the-Group/m-p/599381#M479457 jvitantonio 2014-02-03T09:53:16Z Re: First Row of the Group https://community.qlik.com/t5/QlikView/First-Row-of-the-Group/m-p/599382#M479458 <HTML><HEAD></HEAD><BODY><P>PFA of the file</P></BODY></HTML> Mon, 03 Feb 2014 10:00:20 GMT https://community.qlik.com/t5/QlikView/First-Row-of-the-Group/m-p/599382#M479458 sreenivas 2014-02-03T10:00:20Z Re: First Row of the Group https://community.qlik.com/t5/QlikView/First-Row-of-the-Group/m-p/599383#M479459 <HTML><HEAD></HEAD><BODY><P>Thanks</P></BODY></HTML> Mon, 03 Feb 2014 12:28:15 GMT https://community.qlik.com/t5/QlikView/First-Row-of-the-Group/m-p/599383#M479459 2014-02-03T12:28:15Z Re: First Row of the Group https://community.qlik.com/t5/QlikView/First-Row-of-the-Group/m-p/599384#M479460 <HTML><HEAD></HEAD><BODY><P>Thanks</P><P></P><P>But I also need Batch # of the first row.</P></BODY></HTML> Mon, 03 Feb 2014 13:05:48 GMT https://community.qlik.com/t5/QlikView/First-Row-of-the-Group/m-p/599384#M479460 2014-02-03T13:05:48Z