https://community.qlik.com/t5/App-Development/Month-Numbers-Incremental-going-forward-Every-Year/m-p/1595710#M43847 <P>Hi,</P><P>Steps you need to take:</P><OL><LI>Get a calendar</LI><LI>Load all the months resident</LI><LI>Get Year &amp; '|' &amp; Month as YrMth</LI><LI>Add a line RowNo() as YrMthSeqNr</LI><LI>Left join based on Year Month combination this to your calendar</LI><LI>Link your calendar to your data set based on the date</LI></OL><P>Now you will have your sequence number!</P><P>Jordy</P><P>Climber</P><P>&nbsp;</P> Tue, 25 Jun 2019 13:44:02 GMT JordyWegman 2019-06-25T13:44:02Z https://community.qlik.com/t5/App-Development/Month-Numbers-Incremental-going-forward-Every-Year/m-p/1595205#M43793 <P>Hello Experts,</P><P>&nbsp;</P><P>We have a requirement as Below:</P><P>Currently we have first Month as 2019- May in Our Data Set, we need to assign Number 1 for May, June as 2, July as 3....</P><P>For Next Year if May Comes we should get May as 13, June as 14, July as 15</P><P>All Months Numbers should Increase every year sequentially....</P> Sat, 16 Nov 2024 20:36:02 GMT https://community.qlik.com/t5/App-Development/Month-Numbers-Incremental-going-forward-Every-Year/m-p/1595205#M43793 QlikEnth 2024-11-16T20:36:02Z https://community.qlik.com/t5/App-Development/Month-Numbers-Incremental-going-forward-Every-Year/m-p/1595710#M43847 <P>Hi,</P><P>Steps you need to take:</P><OL><LI>Get a calendar</LI><LI>Load all the months resident</LI><LI>Get Year &amp; '|' &amp; Month as YrMth</LI><LI>Add a line RowNo() as YrMthSeqNr</LI><LI>Left join based on Year Month combination this to your calendar</LI><LI>Link your calendar to your data set based on the date</LI></OL><P>Now you will have your sequence number!</P><P>Jordy</P><P>Climber</P><P>&nbsp;</P> Tue, 25 Jun 2019 13:44:02 GMT https://community.qlik.com/t5/App-Development/Month-Numbers-Incremental-going-forward-Every-Year/m-p/1595710#M43847 JordyWegman 2019-06-25T13:44:02Z