topic Re: Problem with Rowno() in QlikView https://community.qlik.com/t5/QlikView/Problem-with-Rowno/m-p/1293785#M616016 <HTML><HEAD></HEAD><BODY><P>Hi Siva,</P><P></P><P>You can use AutoNumber(RecNo(), ID) AS RowNo</P><P></P><P>Regards,</P><P>David</P></BODY></HTML> Thu, 01 Jun 2017 07:11:33 GMT daveamz 2017-06-01T07:11:33Z Problem with Rowno() https://community.qlik.com/t5/QlikView/Problem-with-Rowno/m-p/1293781#M616010 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P></P><P>I'm facing issue to create rowno based on ID. Please check the below image for your reference what i'm expecting output</P><P></P><P>rowno should starts with 1 for every new ID.&nbsp; Please help me out...<IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/165461_Capture.PNG" style="height: 273px; width: 620px;" /></P></BODY></HTML> Thu, 01 Jun 2017 07:06:11 GMT https://community.qlik.com/t5/QlikView/Problem-with-Rowno/m-p/1293781#M616010 Anonymous 2017-06-01T07:06:11Z Re: Problem with Rowno() https://community.qlik.com/t5/QlikView/Problem-with-Rowno/m-p/1293782#M616011 <HTML><HEAD></HEAD><BODY><P>Please share some sample data....</P></BODY></HTML> Thu, 01 Jun 2017 07:08:06 GMT https://community.qlik.com/t5/QlikView/Problem-with-Rowno/m-p/1293782#M616011 prma7799 2017-06-01T07:08:06Z Re: Problem with Rowno() https://community.qlik.com/t5/QlikView/Problem-with-Rowno/m-p/1293783#M616012 <HTML><HEAD></HEAD><BODY><P>You can do like below in Preceding Load</P><P><STRONG>AutoNumber(RowNo(), ID) as RowNo</STRONG></P></BODY></HTML> Thu, 01 Jun 2017 07:10:18 GMT https://community.qlik.com/t5/QlikView/Problem-with-Rowno/m-p/1293783#M616012 Anil_Babu_Samineni 2017-06-01T07:10:18Z Re: Problem with Rowno() https://community.qlik.com/t5/QlikView/Problem-with-Rowno/m-p/1293784#M616013 <HTML><HEAD></HEAD><BODY><P><IMG alt="row.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/165460_row.png" style="height: auto;" />Or Please try like this</P><P></P><P></P><P></P><P>LOAD * , RowNo();</P><P>LOAD *&nbsp; Inline [</P><P>Id,</P><P>1,</P><P>1,</P><P>1,</P><P>2,</P><P>2,</P><P>2,</P><P>3,</P><P>4</P><P>];</P></BODY></HTML> Thu, 01 Jun 2017 07:11:26 GMT https://community.qlik.com/t5/QlikView/Problem-with-Rowno/m-p/1293784#M616013 prma7799 2017-06-01T07:11:26Z Re: Problem with Rowno() https://community.qlik.com/t5/QlikView/Problem-with-Rowno/m-p/1293785#M616016 <HTML><HEAD></HEAD><BODY><P>Hi Siva,</P><P></P><P>You can use AutoNumber(RecNo(), ID) AS RowNo</P><P></P><P>Regards,</P><P>David</P></BODY></HTML> Thu, 01 Jun 2017 07:11:33 GMT https://community.qlik.com/t5/QlikView/Problem-with-Rowno/m-p/1293785#M616016 daveamz 2017-06-01T07:11:33Z