topic Rowno with aggr for grouping data in App Development https://community.qlik.com/t5/App-Development/Rowno-with-aggr-for-grouping-data/m-p/2082072#M88741 <P>Hi all<BR />I have a table that have some fileds: Calendar,Ticket,Time (min) (sorted in ascending order)<BR />I want to add row no for each Date like the sample bellow.<BR />Important: I want to do this in the load script and not as an expression in a pivot or straight table.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Abbou_0-1686301521565.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/109657iB294352B9DF831D7/image-size/medium?v=v2&amp;px=400" role="button" title="Abbou_0-1686301521565.png" alt="Abbou_0-1686301521565.png" /></span></P> <P>&nbsp;</P> Fri, 09 Jun 2023 09:07:06 GMT Abbou 2023-06-09T09:07:06Z Rowno with aggr for grouping data https://community.qlik.com/t5/App-Development/Rowno-with-aggr-for-grouping-data/m-p/2082072#M88741 <P>Hi all<BR />I have a table that have some fileds: Calendar,Ticket,Time (min) (sorted in ascending order)<BR />I want to add row no for each Date like the sample bellow.<BR />Important: I want to do this in the load script and not as an expression in a pivot or straight table.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Abbou_0-1686301521565.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/109657iB294352B9DF831D7/image-size/medium?v=v2&amp;px=400" role="button" title="Abbou_0-1686301521565.png" alt="Abbou_0-1686301521565.png" /></span></P> <P>&nbsp;</P> Fri, 09 Jun 2023 09:07:06 GMT https://community.qlik.com/t5/App-Development/Rowno-with-aggr-for-grouping-data/m-p/2082072#M88741 Abbou 2023-06-09T09:07:06Z Re: Rowno with aggr for grouping data https://community.qlik.com/t5/App-Development/Rowno-with-aggr-for-grouping-data/m-p/2082113#M88742 <P>Hi&nbsp;</P> <P>&nbsp;</P> <P>May be this in script&nbsp;</P> <P>&nbsp;</P> <P>load&nbsp;</P> <P>autonmumber(Calendar) as Rowno,</P> <P>Calendar,</P> <P>ticket,&nbsp;</P> <P>time&nbsp;</P> <P>from ...</P> Fri, 09 Jun 2023 10:25:41 GMT https://community.qlik.com/t5/App-Development/Rowno-with-aggr-for-grouping-data/m-p/2082113#M88742 brunobertels 2023-06-09T10:25:41Z