topic Re: Count of month number in App Development https://community.qlik.com/t5/App-Development/Count-of-month-number/m-p/1719868#M54730 <P>One solution is.</P><LI-CODE lang="markup">Cal: LOAD Date(AddMonths('1/1/2019',IterNo()-1),'MMM-YY') As FYear, IterNo() As FMonth AutoGenerate 1 While IterNo()&lt;=24 ; </LI-CODE> Thu, 18 Jun 2020 02:55:57 GMT Saravanan_Desingh 2020-06-18T02:55:57Z Count of month number https://community.qlik.com/t5/App-Development/Count-of-month-number/m-p/1705717#M54106 <P>Hello all ,</P><P>I hve&nbsp; year column and I want&nbsp; month count corresponding to year</P><P>For eg&nbsp;</P><P>Year&nbsp; &nbsp; month&nbsp;</P><P>Jan 19&nbsp; &nbsp;1</P><P>Feb 19.&nbsp; 2</P><P>Mar 19&nbsp; &nbsp;3</P><P>.</P><P>.</P><P>.</P><P>Dec19.&nbsp; &nbsp;12</P><P>Jan 20.&nbsp; 13&nbsp;</P><P>Feb 20&nbsp; &nbsp;14</P><P>.</P><P>.</P><P>Dec20.&nbsp; &nbsp;24&nbsp;</P><P>Any ans&nbsp; for this highly appreciated.</P><P>&nbsp;</P><P>Regards,</P><P>Kavita&nbsp;</P><P>&nbsp;</P> Sat, 16 Nov 2024 18:34:50 GMT https://community.qlik.com/t5/App-Development/Count-of-month-number/m-p/1705717#M54106 kavita25 2024-11-16T18:34:50Z Re: Count of month number https://community.qlik.com/t5/App-Development/Count-of-month-number/m-p/1705773#M54111 <P>Hi&nbsp;<SPAN>Kavita ,</SPAN></P><P>&nbsp;</P><P><SPAN>I am not sure if this is what you want,but you can use the "RowNo()" to automatically create a row number.</SPAN></P><P>Regards,</P><P>Paul</P><P>&nbsp;</P><P>Test:<BR />load * inline [<BR />Year<BR />Jan19<BR />Feb19<BR />Mar19<BR />Apr19<BR />May19<BR />Jun19<BR />Jul19<BR />Aug19<BR />Sep19<BR />Oct19<BR />Nov19<BR />Dec19<BR />Jan20<BR />Feb20<BR />Mar20<BR />Apr20<BR />May20<BR />Jun20<BR />Jul20<BR />Aug20<BR />Sep20<BR />Oct20<BR />Nov20<BR />Dec20<BR />];</P><P>Left Join (Test)<BR />Load<BR />Year,<BR />RowNo() As Month<BR />Resident Test;</P><P>&nbsp;</P><P>Result:</P><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV><TABLE width="226"><TBODY><TR><TD width="113">Year</TD><TD width="113">Month</TD></TR><TR><TD>Jan19</TD><TD>1</TD></TR><TR><TD>Feb19</TD><TD>2</TD></TR><TR><TD>Mar19</TD><TD>3</TD></TR><TR><TD>Apr19</TD><TD>4</TD></TR><TR><TD>May19</TD><TD>5</TD></TR><TR><TD>Jun19</TD><TD>6</TD></TR><TR><TD>Jul19</TD><TD>7</TD></TR><TR><TD>Aug19</TD><TD>8</TD></TR><TR><TD>Sep19</TD><TD>9</TD></TR><TR><TD>Oct19</TD><TD>10</TD></TR><TR><TD>Nov19</TD><TD>11</TD></TR><TR><TD>Dec19</TD><TD>12</TD></TR><TR><TD>Jan20</TD><TD>13</TD></TR><TR><TD>Feb20</TD><TD>14</TD></TR><TR><TD>Mar20</TD><TD>15</TD></TR><TR><TD>Apr20</TD><TD>16</TD></TR><TR><TD>May20</TD><TD>17</TD></TR><TR><TD>Jun20</TD><TD>18</TD></TR><TR><TD>Jul20</TD><TD>19</TD></TR><TR><TD>Aug20</TD><TD>20</TD></TR><TR><TD>Sep20</TD><TD>21</TD></TR><TR><TD>Oct20</TD><TD>22</TD></TR><TR><TD>Nov20</TD><TD>23</TD></TR><TR><TD>Dec20</TD><TD>24</TD></TR></TBODY></TABLE><P>&nbsp;</P> Wed, 27 May 2020 17:04:29 GMT https://community.qlik.com/t5/App-Development/Count-of-month-number/m-p/1705773#M54111 paulselousyoriz 2020-05-27T17:04:29Z Re: Count of month number https://community.qlik.com/t5/App-Development/Count-of-month-number/m-p/1719868#M54730 <P>One solution is.</P><LI-CODE lang="markup">Cal: LOAD Date(AddMonths('1/1/2019',IterNo()-1),'MMM-YY') As FYear, IterNo() As FMonth AutoGenerate 1 While IterNo()&lt;=24 ; </LI-CODE> Thu, 18 Jun 2020 02:55:57 GMT https://community.qlik.com/t5/App-Development/Count-of-month-number/m-p/1719868#M54730 Saravanan_Desingh 2020-06-18T02:55:57Z Re: Count of month number https://community.qlik.com/t5/App-Development/Count-of-month-number/m-p/1719870#M54731 <P>Output</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="commQV43.PNG" style="width: 123px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/35758iD0E5D8CFB1A3BE26/image-size/large?v=v2&amp;px=999" role="button" title="commQV43.PNG" alt="commQV43.PNG" /></span></P> Thu, 18 Jun 2020 02:56:33 GMT https://community.qlik.com/t5/App-Development/Count-of-month-number/m-p/1719870#M54731 Saravanan_Desingh 2020-06-18T02:56:33Z