topic Re: Generate Sequence in QlikView https://community.qlik.com/t5/QlikView/Generate-Sequence/m-p/559324#M692676 <HTML><HEAD></HEAD><BODY><P>Thank you!</P></BODY></HTML> Mon, 05 Aug 2013 16:48:37 GMT 2013-08-05T16:48:37Z Generate Sequence https://community.qlik.com/t5/QlikView/Generate-Sequence/m-p/559322#M692674 <HTML><HEAD></HEAD><BODY><P>Hello!</P><P>Help me please ...</P><P></P><P></P><P>I have the following table and need to create a new column with a numeric sequence according to the amount of photos of each product.</P><P></P><P><IMG __jive_id="44950" class="jive-image" alt="tab1.jpg" src="https://community.qlik.com/legacyfs/online/44950_tab1.jpg" /></P><P></P><P>I wish the results were as shown below:</P><P></P><P><IMG __jive_id="44951" class="jive-image" alt="tab2.jpg" src="https://community.qlik.com/legacyfs/online/44951_tab2.jpg" /></P></BODY></HTML> Mon, 05 Aug 2013 14:35:15 GMT https://community.qlik.com/t5/QlikView/Generate-Sequence/m-p/559322#M692674 2013-08-05T14:35:15Z Re: Generate Sequence https://community.qlik.com/t5/QlikView/Generate-Sequence/m-p/559323#M692675 <HTML><HEAD></HEAD><BODY><P>LOAD idProduct, </P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; urlPhoto,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if( peek(idProduct) = idProduct, peek(Sequence)+1, 1) as Sequence</P><P>RESIDENT photos;</P></BODY></HTML> Mon, 05 Aug 2013 14:40:27 GMT https://community.qlik.com/t5/QlikView/Generate-Sequence/m-p/559323#M692675 luciancotea 2013-08-05T14:40:27Z Re: Generate Sequence https://community.qlik.com/t5/QlikView/Generate-Sequence/m-p/559324#M692676 <HTML><HEAD></HEAD><BODY><P>Thank you!</P></BODY></HTML> Mon, 05 Aug 2013 16:48:37 GMT https://community.qlik.com/t5/QlikView/Generate-Sequence/m-p/559324#M692676 2013-08-05T16:48:37Z Re: Generate Sequence https://community.qlik.com/t5/QlikView/Generate-Sequence/m-p/559325#M692677 <HTML><HEAD></HEAD><BODY><P>I think much easier is </P><P></P><P>autonumber(Recno(), idNumber) as Sequence</P><P></P><P>-Rob</P></BODY></HTML> Mon, 05 Aug 2013 19:45:02 GMT https://community.qlik.com/t5/QlikView/Generate-Sequence/m-p/559325#M692677 rwunderlich 2013-08-05T19:45:02Z