topic group by in qlikview in QlikView https://community.qlik.com/t5/QlikView/group-by-in-qlikview/m-p/790970#M279687 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>I have table like below.</P><P><IMG class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/81890_pastedImage_2.png" style="max-width: 1200px; max-height: 900px;" /></P><P>i want to restrict the table to show only Max(line_no) on each unique loaded file. i want output as below. Please help me how we can fix.</P><P></P><P><IMG class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/81891_pastedImage_3.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Wed, 25 Mar 2015 14:11:20 GMT Anonymous 2015-03-25T14:11:20Z group by in qlikview https://community.qlik.com/t5/QlikView/group-by-in-qlikview/m-p/790970#M279687 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>I have table like below.</P><P><IMG class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/81890_pastedImage_2.png" style="max-width: 1200px; max-height: 900px;" /></P><P>i want to restrict the table to show only Max(line_no) on each unique loaded file. i want output as below. Please help me how we can fix.</P><P></P><P><IMG class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/81891_pastedImage_3.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Wed, 25 Mar 2015 14:11:20 GMT https://community.qlik.com/t5/QlikView/group-by-in-qlikview/m-p/790970#M279687 Anonymous 2015-03-25T14:11:20Z Re: group by in qlikview https://community.qlik.com/t5/QlikView/group-by-in-qlikview/m-p/790971#M279688 <HTML><HEAD></HEAD><BODY><P>Not sure if you are looking for something like this:</P><P></P><P><STRONG>LOAD Loaded_File</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Max(Line_No) as Max Line_No</STRONG></P><P><STRONG>Resident sourceTable</STRONG></P><P><STRONG>Group By Loaded_File</STRONG></P><P></P><P>HTH</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Wed, 25 Mar 2015 14:22:38 GMT https://community.qlik.com/t5/QlikView/group-by-in-qlikview/m-p/790971#M279688 sunny_talwar 2015-03-25T14:22:38Z Re: group by in qlikview https://community.qlik.com/t5/QlikView/group-by-in-qlikview/m-p/790972#M279689 <HTML><HEAD></HEAD><BODY><P>try sunindia advice,hopes it works.</P></BODY></HTML> Wed, 25 Mar 2015 17:09:29 GMT https://community.qlik.com/t5/QlikView/group-by-in-qlikview/m-p/790972#M279689 buzzy996 2015-03-25T17:09:29Z