topic Re: How to create row number that for &quot;sun&quot; table. like 1.1, 1.2, 2.1, 2.2 in QlikView https://community.qlik.com/t5/QlikView/How-to-create-row-number-that-for-quot-sun-quot-table-like-1-1-1/m-p/1447048#M611740 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">thanks,</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">But the loading a takes a very long time</P></BODY></HTML> Thu, 16 Nov 2017 16:37:14 GMT Xabinav 2017-11-16T16:37:14Z How to create row number that for "sun" table. like 1.1, 1.2, 2.1, 2.2 https://community.qlik.com/t5/QlikView/How-to-create-row-number-that-for-quot-sun-quot-table-like-1-1-1/m-p/1447046#M611738 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I want to create the <STRONG>"order line"</STRONG> field like at 2. table</P><P>for each order id create&nbsp; row number that group by his order id.</P><P>How can i do that. </P><P>thank's </P><P></P><P>1.</P><TABLE border="1" class="jiveBorder" height="99" style="border: 1px solid #000000; width: 148px; height: 99px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">order id</TH></TR><TR><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">2</TD></TR><TR><TD style="padding: 2px;">3</TD></TR></TBODY></TABLE><P></P><P>2.</P><TABLE border="1" class="jiveBorder" height="149" style="border: 1px solid #000000; width: 156px; height: 144px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>order id</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><SPAN style="color: #ccffff;"><STRONG>order line</STRONG></SPAN></TH></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">1.1</TD></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">1.2</TD></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">1.3</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">2.1</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">2.2</TD></TR></TBODY></TABLE></BODY></HTML> Thu, 09 Nov 2017 16:30:47 GMT https://community.qlik.com/t5/QlikView/How-to-create-row-number-that-for-quot-sun-quot-table-like-1-1-1/m-p/1447046#M611738 Xabinav 2017-11-09T16:30:47Z Re: How to create row number that for "sun" table. like 1.1, 1.2, 2.1, 2.2 https://community.qlik.com/t5/QlikView/How-to-create-row-number-that-for-quot-sun-quot-table-like-1-1-1/m-p/1447047#M611739 <HTML><HEAD></HEAD><BODY><P>May be like this</P><P></P><P>LOAD [order id],</P><P>&nbsp;&nbsp;&nbsp;&nbsp; [order id] &amp; '.' &amp; AutoNumber(RowNo(), [order id]) as [order line]</P><P>FROM ...</P></BODY></HTML> Thu, 09 Nov 2017 16:33:43 GMT https://community.qlik.com/t5/QlikView/How-to-create-row-number-that-for-quot-sun-quot-table-like-1-1-1/m-p/1447047#M611739 sunny_talwar 2017-11-09T16:33:43Z Re: How to create row number that for "sun" table. like 1.1, 1.2, 2.1, 2.2 https://community.qlik.com/t5/QlikView/How-to-create-row-number-that-for-quot-sun-quot-table-like-1-1-1/m-p/1447048#M611740 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">thanks,</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">But the loading a takes a very long time</P></BODY></HTML> Thu, 16 Nov 2017 16:37:14 GMT https://community.qlik.com/t5/QlikView/How-to-create-row-number-that-for-quot-sun-quot-table-like-1-1-1/m-p/1447048#M611740 Xabinav 2017-11-16T16:37:14Z Re: How to create row number that for "sun" table. like 1.1, 1.2, 2.1, 2.2 https://community.qlik.com/t5/QlikView/How-to-create-row-number-that-for-quot-sun-quot-table-like-1-1-1/m-p/1447049#M611741 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;">The other option is this</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"><STRONG>LOAD [order id],</STRONG></P><P style="font-size: 13.3333px;"><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">[order id] &amp; '.' &amp; Rank as [order line];</SPAN></STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>LOAD [order id],</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>&nbsp;&nbsp;&nbsp;&nbsp; If(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">[order id] = Previous(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">[order id]), RangeSum(Peek('Rank'), 1), 1)</SPAN></SPAN> as Rank</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>FROM ...</STRONG></P></BODY></HTML> Thu, 16 Nov 2017 16:38:28 GMT https://community.qlik.com/t5/QlikView/How-to-create-row-number-that-for-quot-sun-quot-table-like-1-1-1/m-p/1447049#M611741 sunny_talwar 2017-11-16T16:38:28Z