topic How to generate sequence number for each item ? in QlikView https://community.qlik.com/t5/QlikView/How-to-generate-sequence-number-for-each-item/m-p/228677#M80683 <HTML><HEAD></HEAD><BODY><P>Hi Viktor,</P><P>please see my first shot.</P><P>A step forward I hope.</P><P>Good luck!</P><P>Rainer</P></BODY></HTML> Thu, 24 Feb 2011 13:03:12 GMT 2011-02-24T13:03:12Z How to generate sequence number for each item ? https://community.qlik.com/t5/QlikView/How-to-generate-sequence-number-for-each-item/m-p/228676#M80682 <HTML><HEAD></HEAD><BODY><P>Hello, dear all!</P><P>Please help with advice how to perform this.</P><P>I have a table with ITEMID and OPERATIONNUMBER.</P><P>Excel File:</P><P>[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/2117.ItemsOperations.xls:550:0]</P><P>It is sorted by ITEMID, OPERATIONUMBER.</P><P>How can I generate SEQUENCE number in third colum to look like in excel file.</P><P>Maybe it can be preformed with some loop ?</P><P>Thank you!!!</P></BODY></HTML> Thu, 24 Feb 2011 12:30:00 GMT https://community.qlik.com/t5/QlikView/How-to-generate-sequence-number-for-each-item/m-p/228676#M80682 2011-02-24T12:30:00Z How to generate sequence number for each item ? https://community.qlik.com/t5/QlikView/How-to-generate-sequence-number-for-each-item/m-p/228677#M80683 <HTML><HEAD></HEAD><BODY><P>Hi Viktor,</P><P>please see my first shot.</P><P>A step forward I hope.</P><P>Good luck!</P><P>Rainer</P></BODY></HTML> Thu, 24 Feb 2011 13:03:12 GMT https://community.qlik.com/t5/QlikView/How-to-generate-sequence-number-for-each-item/m-p/228677#M80683 2011-02-24T13:03:12Z How to generate sequence number for each item ? https://community.qlik.com/t5/QlikView/How-to-generate-sequence-number-for-each-item/m-p/228678#M80684 <HTML><HEAD></HEAD><BODY><P>Thanks a lot <STRONG>Rainer.</STRONG></P><P>It works!</P><P>Maybe you can give the advice how to mark last sequnce for item as '999' ?</P><P>Thank you!</P></BODY></HTML> Thu, 24 Feb 2011 13:38:12 GMT https://community.qlik.com/t5/QlikView/How-to-generate-sequence-number-for-each-item/m-p/228678#M80684 2011-02-24T13:38:12Z How to generate sequence number for each item ? https://community.qlik.com/t5/QlikView/How-to-generate-sequence-number-for-each-item/m-p/228679#M80685 <HTML><HEAD></HEAD><BODY><P>Viktor,</P><P>maybe a better way exists to get what you want.</P><P>But it works so far.</P><P>Good luck!</P><P>Rainer</P></BODY></HTML> Thu, 24 Feb 2011 15:57:09 GMT https://community.qlik.com/t5/QlikView/How-to-generate-sequence-number-for-each-item/m-p/228679#M80685 2011-02-24T15:57:09Z How to generate sequence number for each item ? https://community.qlik.com/t5/QlikView/How-to-generate-sequence-number-for-each-item/m-p/228680#M80686 <HTML><HEAD></HEAD><BODY><P>Thanks a lot!!!</P><P>This works and it is a solution for me.</P><P>At least something.</P><P>Many thanks to you <STRONG><A href="http://community.qlik.com/members/rfa/default.aspx">Rainer</A>,</STRONG> you helped me very much!!</P></BODY></HTML> Thu, 24 Feb 2011 16:25:59 GMT https://community.qlik.com/t5/QlikView/How-to-generate-sequence-number-for-each-item/m-p/228680#M80686 2011-02-24T16:25:59Z