topic Re: Creating new field to mark each record in QlikView

topic Re: Creating new field to mark each record in QlikView https://community.qlik.com/t5/QlikView/Creating-new-field-to-mark-each-record/m-p/1732364#M592338 <P>Try like:</P><P>Autonumber(CID, New_Site) as RollingNo</P> Fri, 31 Jul 2020 09:22:26 GMT tresB 2020-07-31T09:22:26Z Creating new field to mark each record https://community.qlik.com/t5/QlikView/Creating-new-field-to-mark-each-record/m-p/1732353#M592337 <P>Hi, </P><P>I need to mark each record based on CID, New_Site and Weekingdate. </P><P>Script</P><P>LOAD</P><P><BR />CID,</P><P>New_Site,<BR />Weekending,</P><P>from ...</P><P>CID contains unique data, New_Site and Weekending are not. </P><TABLE width="334"><TBODY><TR><TD width="117">CID</TD><TD width="137">New_Site</TD><TD width="80">Weekending</TD></TR><TR><TD>CRS6CI00143608</TD><TD>DST</TD><TD>26/07/2020</TD></TR><TR><TD>CRS6CI00143914</TD><TD>Devonport</TD><TD>26/07/2020</TD></TR><TR><TD>CRS6CI00143998</TD><TD>Edinburgh</TD><TD>26/07/2020</TD></TR><TR><TD>CRS6CI00143564</TD><TD>Cavendish Nuclear (SAP)</TD><TD>26/07/2020</TD></TR><TR><TD>CRS6CI00143554</TD><TD>Edinburgh</TD><TD>26/07/2020</TD></TR><TR><TD>CRS6CI00143762</TD><TD>Devonport</TD><TD>26/07/2020</TD></TR><TR><TD>CRS6CI00143780</TD><TD>DST</TD><TD>26/07/2020</TD></TR><TR><TD>CRS6CI00144028</TD><TD>Rosyth</TD><TD>26/07/2020</TD></TR><TR><TD>CRS6CI00144030</TD><TD>Rosyth</TD><TD>26/07/2020</TD></TR><TR><TD>CRS6CI00144024</TD><TD>Edinburgh</TD><TD>26/07/2020</TD></TR><TR><TD>CRS6CI00143636</TD><TD>Edinburgh</TD><TD>26/07/2020</TD></TR><TR><TD>CRS6CI00143652</TD><TD>Skills & Learning</TD><TD>26/07/2020</TD></TR><TR><TD>CRS6CI00143991</TD><TD>Devonport</TD><TD>26/07/2020</TD></TR><TR><TD>CRS6CI00143665</TD><TD>Devonport</TD><TD>26/07/2020</TD></TR><TR><TD>CRS6CI00143642</TD><TD>Devonport</TD><TD>26/07/2020</TD></TR><TR><TD>CRS6CI00143778</TD><TD>Devonport</TD><TD>26/07/2020</TD></TR><TR><TD>CRS6CI00143719</TD><TD>D & S</TD><TD>26/07/2020</TD></TR><TR><TD>CRS6CI00143586</TD><TD>Cavendish Nuclear (SAP)</TD><TD>26/07/2020</TD></TR><TR><TD>CRS6CI00143886</TD><TD>Devonport</TD><TD>26/07/2020</TD></TR><TR><TD>CRS6CI00143670</TD><TD>Cavendish Nuclear (SAP)</TD><TD>26/07/2020</TD></TR></TBODY></TABLE><P> </P><P>This is the data set in am loading and i need to mark each CID with the rolling number so example</P><TABLE width="349"><TBODY><TR><TD width="93">CID</TD><TD width="128">New_Site</TD><TD width="64">Weekending</TD><TD width="64">Rolling No</TD></TR><TR><TD>CRS6CI00143564</TD><TD>Cavendish Nuclear (SAP)</TD><TD>26/07/2020</TD><TD>1</TD></TR><TR><TD>CRS6CI00143586</TD><TD>Cavendish Nuclear (SAP)</TD><TD>26/07/2020</TD><TD>2</TD></TR><TR><TD>CRS6CI00143670</TD><TD>Cavendish Nuclear (SAP)</TD><TD>26/07/2020</TD><TD>3</TD></TR><TR><TD>CRS6CI00143719</TD><TD>D & S</TD><TD>26/07/2020</TD><TD>1</TD></TR><TR><TD>CRS6CI00143914</TD><TD>Devonport</TD><TD>26/07/2020</TD><TD>1</TD></TR><TR><TD>CRS6CI00143762</TD><TD>Devonport</TD><TD>26/07/2020</TD><TD>2</TD></TR><TR><TD>CRS6CI00143991</TD><TD>Devonport</TD><TD>26/07/2020</TD><TD>3</TD></TR><TR><TD>CRS6CI00143665</TD><TD>Devonport</TD><TD>26/07/2020</TD><TD>4</TD></TR><TR><TD>CRS6CI00143642</TD><TD>Devonport</TD><TD>26/07/2020</TD><TD>5</TD></TR><TR><TD>CRS6CI00143778</TD><TD>Devonport</TD><TD>26/07/2020</TD><TD>6</TD></TR><TR><TD>CRS6CI00143886</TD><TD>Devonport</TD><TD>26/07/2020</TD><TD>7</TD></TR><TR><TD>CRS6CI00143608</TD><TD>DST</TD><TD>26/07/2020</TD><TD>1</TD></TR><TR><TD>CRS6CI00143780</TD><TD>DST</TD><TD>26/07/2020</TD><TD>2</TD></TR><TR><TD>CRS6CI00143998</TD><TD>Edinburgh</TD><TD>26/07/2020</TD><TD>1</TD></TR><TR><TD>CRS6CI00143554</TD><TD>Edinburgh</TD><TD>26/07/2020</TD><TD>2</TD></TR><TR><TD>CRS6CI00144024</TD><TD>Edinburgh</TD><TD>26/07/2020</TD><TD>3</TD></TR><TR><TD>CRS6CI00143636</TD><TD>Edinburgh</TD><TD>26/07/2020</TD><TD>4</TD></TR><TR><TD>CRS6CI00144028</TD><TD>Rosyth</TD><TD>26/07/2020</TD><TD>1</TD></TR><TR><TD>CRS6CI00144030</TD><TD>Rosyth</TD><TD>26/07/2020</TD><TD>2</TD></TR><TR><TD>CRS6CI00143652</TD><TD>Skills & Learning</TD><TD>26/07/2020</TD><TD>1</TD></TR></TBODY></TABLE><P> </P><P>Thanks</P><P> </P> Sat, 16 Nov 2024 00:12:59 GMT https://community.qlik.com/t5/QlikView/Creating-new-field-to-mark-each-record/m-p/1732353#M592337 jagjivvt 2024-11-16T00:12:59Z Re: Creating new field to mark each record https://community.qlik.com/t5/QlikView/Creating-new-field-to-mark-each-record/m-p/1732364#M592338 <P>Try like:</P><P>Autonumber(CID, New_Site) as RollingNo</P> Fri, 31 Jul 2020 09:22:26 GMT https://community.qlik.com/t5/QlikView/Creating-new-field-to-mark-each-record/m-p/1732364#M592338 tresB 2020-07-31T09:22:26Z Re: Creating new field to mark each record https://community.qlik.com/t5/QlikView/Creating-new-field-to-mark-each-record/m-p/1732388#M592339 <P>Thanks, </P><P>It worked perfect. i changed it to </P><P>Autonumber( CID,New_Site& Weekending) as RollingNo</P><P>and i now see the grouping</P><TABLE width="416"><TBODY><TR><TD width="96">BBGrpControl</TD><TD width="96">Weekending</TD><TD width="128">New_Site</TD><TD width="96">Count(CID)</TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD>371</TD></TR><TR><TD>BBG1</TD><TD>26/07/2020</TD><TD>Cavendish Nuclear (SAP)</TD><TD>50</TD></TR><TR><TD>BBG2</TD><TD>26/07/2020</TD><TD>Cavendish Nuclear (SAP)</TD><TD>50</TD></TR><TR><TD>BBG3</TD><TD>26/07/2020</TD><TD>Cavendish Nuclear (SAP)</TD><TD>50</TD></TR><TR><TD>BBG4</TD><TD>26/07/2020</TD><TD>Cavendish Nuclear (SAP)</TD><TD>50</TD></TR><TR><TD>BBG5</TD><TD>26/07/2020</TD><TD>Cavendish Nuclear (SAP)</TD><TD>50</TD></TR><TR><TD>BBG6</TD><TD>26/07/2020</TD><TD>Cavendish Nuclear (SAP)</TD><TD>50</TD></TR><TR><TD>BBG7</TD><TD>26/07/2020</TD><TD>Cavendish Nuclear (SAP)</TD><TD>50</TD></TR><TR><TD>BBG8</TD><TD>26/07/2020</TD><TD>Cavendish Nuclear (SAP)</TD><TD>21</TD></TR></TBODY></TABLE><P> </P><P>as it created and group for every 50 records. </P><P>thank you for all your help. </P><P>vijay</P> Fri, 31 Jul 2020 10:13:25 GMT https://community.qlik.com/t5/QlikView/Creating-new-field-to-mark-each-record/m-p/1732388#M592339 jagjivvt 2020-07-31T10:13:25Z