topic Re: How to count the number of closed months in qlik scripting? in App Development https://community.qlik.com/t5/App-Development/How-to-count-the-number-of-closed-months-in-qlik-scripting/m-p/2492765#M102234 <P>I didnt really understan what you are trying to get here? are looking for months that are past the current month?</P> Thu, 14 Nov 2024 13:57:21 GMT Qrishna 2024-11-14T13:57:21Z How to count the number of closed months in qlik scripting? https://community.qlik.com/t5/App-Development/How-to-count-the-number-of-closed-months-in-qlik-scripting/m-p/2480906#M100755 <P>Hello Team,</P> <P>I have a FiscalMonth and FiscalYear Fields(Fiscal Year starts on October), and i have a data from last 4 years, now i want to create a field to count the number of closed months, please help me on this. Attached requirement.</P> <TABLE width="540"> <TBODY> <TR> <TD width="85">Fiscal_Month</TD> <TD width="74">Fiscal_Year</TD> <TD width="97">Last 12 months</TD> <TD width="96">Last 16 Months</TD> <TD width="96">last 24 months</TD> <TD width="92">closed Months</TD> </TR> <TR> <TD>202110</TD> <TD>2022</TD> <TD>2022</TD> <TD>2022</TD> <TD>2022</TD> <TD>12</TD> </TR> <TR> <TD>202111</TD> <TD>2022</TD> <TD>2022</TD> <TD>2022</TD> <TD>2022</TD> <TD>12</TD> </TR> <TR> <TD>202112</TD> <TD>2022</TD> <TD>2022</TD> <TD>2022</TD> <TD>2022</TD> <TD>12</TD> </TR> <TR> <TD>202201</TD> <TD>2022</TD> <TD>2022</TD> <TD>2022</TD> <TD>2022</TD> <TD>12</TD> </TR> <TR> <TD>202202</TD> <TD>2022</TD> <TD>2022</TD> <TD>2022</TD> <TD>2022</TD> <TD>12</TD> </TR> <TR> <TD>202203</TD> <TD>2022</TD> <TD>2022</TD> <TD>2022</TD> <TD>2022</TD> <TD>12</TD> </TR> <TR> <TD>202204</TD> <TD>2022</TD> <TD>2022</TD> <TD>2022</TD> <TD>2022</TD> <TD>12</TD> </TR> <TR> <TD>202205</TD> <TD>2022</TD> <TD>2022</TD> <TD>2022</TD> <TD>2022</TD> <TD>12</TD> </TR> <TR> <TD>202206</TD> <TD>2022</TD> <TD>2022</TD> <TD>2022</TD> <TD>2022</TD> <TD>12</TD> </TR> <TR> <TD>202207</TD> <TD>2022</TD> <TD>2022</TD> <TD>2022</TD> <TD>2022</TD> <TD>12</TD> </TR> <TR> <TD>202208</TD> <TD>2022</TD> <TD>2022</TD> <TD>2022</TD> <TD>2022</TD> <TD>12</TD> </TR> <TR> <TD>202209</TD> <TD>2022</TD> <TD>2022</TD> <TD>2022</TD> <TD>2022</TD> <TD>12</TD> </TR> <TR> <TD>202210</TD> <TD>2023</TD> <TD>2023</TD> <TD>2023</TD> <TD>2023</TD> <TD>12</TD> </TR> <TR> <TD>202211</TD> <TD>2023</TD> <TD>2023</TD> <TD>2023</TD> <TD>2023</TD> <TD>12</TD> </TR> <TR> <TD>202212</TD> <TD>2023</TD> <TD>2023</TD> <TD>2023</TD> <TD>2023</TD> <TD>12</TD> </TR> <TR> <TD>202301</TD> <TD>2023</TD> <TD>2023</TD> <TD>2023</TD> <TD>2023</TD> <TD>12</TD> </TR> <TR> <TD>202302</TD> <TD>2023</TD> <TD>2023</TD> <TD>2023</TD> <TD>2023</TD> <TD>12</TD> </TR> <TR> <TD>202303</TD> <TD>2023</TD> <TD>2023</TD> <TD>2023</TD> <TD>2023</TD> <TD>12</TD> </TR> <TR> <TD>202304</TD> <TD>2023</TD> <TD>2023</TD> <TD>2023</TD> <TD>2023</TD> <TD>12</TD> </TR> <TR> <TD>202305</TD> <TD>2023</TD> <TD>2023</TD> <TD>2023</TD> <TD>2023</TD> <TD>12</TD> </TR> <TR> <TD>202306</TD> <TD>2023</TD> <TD>2023</TD> <TD>2023</TD> <TD>2023</TD> <TD>12</TD> </TR> <TR> <TD>202307</TD> <TD>2023</TD> <TD>2023</TD> <TD>2023</TD> <TD>2023</TD> <TD>12</TD> </TR> <TR> <TD>202308</TD> <TD>2023</TD> <TD>2023</TD> <TD>2023</TD> <TD>2023</TD> <TD>12</TD> </TR> <TR> <TD>202309</TD> <TD>2023</TD> <TD>2023</TD> <TD>2023</TD> <TD>2023</TD> <TD>12</TD> </TR> <TR> <TD>202310</TD> <TD>2024</TD> <TD>2024</TD> <TD>2024</TD> <TD>2024</TD> <TD>11</TD> </TR> <TR> <TD>202311</TD> <TD>2024</TD> <TD>2024</TD> <TD>2024</TD> <TD>2024</TD> <TD>11</TD> </TR> <TR> <TD>202312</TD> <TD>2024</TD> <TD>2024</TD> <TD>2024</TD> <TD>2024</TD> <TD>11</TD> </TR> <TR> <TD>202401</TD> <TD>2024</TD> <TD>2024</TD> <TD>2024</TD> <TD>2024</TD> <TD>11</TD> </TR> <TR> <TD>202402</TD> <TD>2024</TD> <TD>2024</TD> <TD>2024</TD> <TD>2024</TD> <TD>11</TD> </TR> <TR> <TD>202403</TD> <TD>2024</TD> <TD>2024</TD> <TD>2024</TD> <TD>2024</TD> <TD>11</TD> </TR> <TR> <TD>202404</TD> <TD>2024</TD> <TD>2024</TD> <TD>2024</TD> <TD>2024</TD> <TD>11</TD> </TR> <TR> <TD>202405</TD> <TD>2024</TD> <TD>2024</TD> <TD>2024</TD> <TD>2024</TD> <TD>11</TD> </TR> <TR> <TD>202406</TD> <TD>2024</TD> <TD>2024</TD> <TD>2024</TD> <TD>2024</TD> <TD>11</TD> </TR> <TR> <TD>202407</TD> <TD>2024</TD> <TD>2024</TD> <TD>2024</TD> <TD>2024</TD> <TD>11</TD> </TR> <TR> <TD>202408</TD> <TD>2024</TD> <TD>2024</TD> <TD>2024</TD> <TD>2024</TD> <TD>11</TD> </TR> <TR> <TD>202408</TD> <TD>-</TD> <TD>-</TD> <TD>-</TD> <TD>Last 24 Months</TD> <TD>24</TD> </TR> <TR> <TD>202407</TD> <TD>-</TD> <TD>-</TD> <TD>-</TD> <TD>Last 24 Months</TD> <TD>24</TD> </TR> <TR> <TD>202406</TD> <TD>-</TD> <TD>-</TD> <TD>-</TD> <TD>Last 24 Months</TD> <TD>24</TD> </TR> <TR> <TD>202405</TD> <TD>-</TD> <TD>-</TD> <TD>-</TD> <TD>Last 24 Months</TD> <TD>24</TD> </TR> <TR> <TD>202404</TD> <TD>-</TD> <TD>-</TD> <TD>-</TD> <TD>Last 24 Months</TD> <TD>24</TD> </TR> <TR> <TD>202403</TD> <TD>-</TD> <TD>-</TD> <TD>-</TD> <TD>Last 24 Months</TD> <TD>24</TD> </TR> <TR> <TD>202402</TD> <TD>-</TD> <TD>-</TD> <TD>-</TD> <TD>Last 24 Months</TD> <TD>24</TD> </TR> <TR> <TD>202401</TD> <TD>-</TD> <TD>-</TD> <TD>-</TD> <TD>Last 24 Months</TD> <TD>24</TD> </TR> <TR> <TD>202312</TD> <TD>-</TD> <TD>-</TD> <TD>-</TD> <TD>Last 24 Months</TD> <TD>24</TD> </TR> <TR> <TD>202311</TD> <TD>-</TD> <TD>-</TD> <TD>-</TD> <TD>Last 24 Months</TD> <TD>24</TD> </TR> <TR> <TD>202310</TD> <TD>-</TD> <TD>-</TD> <TD>-</TD> <TD>Last 24 Months</TD> <TD>24</TD> </TR> <TR> <TD>202309</TD> <TD>-</TD> <TD>-</TD> <TD>-</TD> <TD>Last 24 Months</TD> <TD>24</TD> </TR> <TR> <TD>202308</TD> <TD>-</TD> <TD>-</TD> <TD>-</TD> <TD>Last 24 Months</TD> <TD>24</TD> </TR> <TR> <TD>202307</TD> <TD>-</TD> <TD>-</TD> <TD>-</TD> <TD>Last 24 Months</TD> <TD>24</TD> </TR> <TR> <TD>202306</TD> <TD>-</TD> <TD>-</TD> <TD>-</TD> <TD>Last 24 Months</TD> <TD>24</TD> </TR> <TR> <TD>202305</TD> <TD>-</TD> <TD>-</TD> <TD>-</TD> <TD>Last 24 Months</TD> <TD>24</TD> </TR> <TR> <TD>202304</TD> <TD>-</TD> <TD>-</TD> <TD>-</TD> <TD>Last 24 Months</TD> <TD>24</TD> </TR> <TR> <TD>202303</TD> <TD>-</TD> <TD>-</TD> <TD>-</TD> <TD>Last 24 Months</TD> <TD>24</TD> </TR> <TR> <TD>202302</TD> <TD>-</TD> <TD>-</TD> <TD>-</TD> <TD>Last 24 Months</TD> <TD>24</TD> </TR> <TR> <TD>202301</TD> <TD>-</TD> <TD>-</TD> <TD>-</TD> <TD>Last 24 Months</TD> <TD>24</TD> </TR> <TR> <TD>202212</TD> <TD>-</TD> <TD>-</TD> <TD>-</TD> <TD>Last 24 Months</TD> <TD>24</TD> </TR> <TR> <TD>202211</TD> <TD>-</TD> <TD>-</TD> <TD>-</TD> <TD>Last 24 Months</TD> <TD>24</TD> </TR> <TR> <TD>202210</TD> <TD>-</TD> <TD>-</TD> <TD>-</TD> <TD>Last 24 Months</TD> <TD>24</TD> </TR> <TR> <TD>202209</TD> <TD>-</TD> <TD>-</TD> <TD>-</TD> <TD>Last 24 Months</TD> <TD>24</TD> </TR> <TR> <TD>202408</TD> <TD>-</TD> <TD>-</TD> <TD>Last 16 Months</TD> <TD>-</TD> <TD>16</TD> </TR> <TR> <TD>202407</TD> <TD>-</TD> <TD>-</TD> <TD>Last 16 Months</TD> <TD>-</TD> <TD>16</TD> </TR> <TR> <TD>202406</TD> <TD>-</TD> <TD>-</TD> <TD>Last 16 Months</TD> <TD>-</TD> <TD>16</TD> </TR> <TR> <TD>202405</TD> <TD>-</TD> <TD>-</TD> <TD>Last 16 Months</TD> <TD>-</TD> <TD>16</TD> </TR> <TR> <TD>202404</TD> <TD>-</TD> <TD>-</TD> <TD>Last 16 Months</TD> <TD>-</TD> <TD>16</TD> </TR> <TR> <TD>202403</TD> <TD>-</TD> <TD>-</TD> <TD>Last 16 Months</TD> <TD>-</TD> <TD>16</TD> </TR> <TR> <TD>202402</TD> <TD>-</TD> <TD>-</TD> <TD>Last 16 Months</TD> <TD>-</TD> <TD>16</TD> </TR> <TR> <TD>202401</TD> <TD>-</TD> <TD>-</TD> <TD>Last 16 Months</TD> <TD>-</TD> <TD>16</TD> </TR> <TR> <TD>202312</TD> <TD>-</TD> <TD>-</TD> <TD>Last 16 Months</TD> <TD>-</TD> <TD>16</TD> </TR> <TR> <TD>202311</TD> <TD>-</TD> <TD>-</TD> <TD>Last 16 Months</TD> <TD>-</TD> <TD>16</TD> </TR> <TR> <TD>202310</TD> <TD>-</TD> <TD>-</TD> <TD>Last 16 Months</TD> <TD>-</TD> <TD>16</TD> </TR> <TR> <TD>202309</TD> <TD>-</TD> <TD>-</TD> <TD>Last 16 Months</TD> <TD>-</TD> <TD>16</TD> </TR> <TR> <TD>202308</TD> <TD>-</TD> <TD>-</TD> <TD>Last 16 Months</TD> <TD>-</TD> <TD>16</TD> </TR> <TR> <TD>202307</TD> <TD>-</TD> <TD>-</TD> <TD>Last 16 Months</TD> <TD>-</TD> <TD>16</TD> </TR> <TR> <TD>202306</TD> <TD>-</TD> <TD>-</TD> <TD>Last 16 Months</TD> <TD>-</TD> <TD>16</TD> </TR> <TR> <TD>202305</TD> <TD>-</TD> <TD>-</TD> <TD>Last 16 Months</TD> <TD>-</TD> <TD>16</TD> </TR> <TR> <TD>202408</TD> <TD>-</TD> <TD>Last 12 Months</TD> <TD>-</TD> <TD>-</TD> <TD>12</TD> </TR> <TR> <TD>202407</TD> <TD>-</TD> <TD>Last 12 Months</TD> <TD>-</TD> <TD>-</TD> <TD>12</TD> </TR> <TR> <TD>202406</TD> <TD>-</TD> <TD>Last 12 Months</TD> <TD>-</TD> <TD>-</TD> <TD>12</TD> </TR> <TR> <TD>202405</TD> <TD>-</TD> <TD>Last 12 Months</TD> <TD>-</TD> <TD>-</TD> <TD>12</TD> </TR> <TR> <TD>202404</TD> <TD>-</TD> <TD>Last 12 Months</TD> <TD>-</TD> <TD>-</TD> <TD>12</TD> </TR> <TR> <TD>202403</TD> <TD>-</TD> <TD>Last 12 Months</TD> <TD>-</TD> <TD>-</TD> <TD>12</TD> </TR> <TR> <TD>202402</TD> <TD>-</TD> <TD>Last 12 Months</TD> <TD>-</TD> <TD>-</TD> <TD>12</TD> </TR> <TR> <TD>202401</TD> <TD>-</TD> <TD>Last 12 Months</TD> <TD>-</TD> <TD>-</TD> <TD>12</TD> </TR> <TR> <TD>202312</TD> <TD>-</TD> <TD>Last 12 Months</TD> <TD>-</TD> <TD>-</TD> <TD>12</TD> </TR> <TR> <TD>202311</TD> <TD>-</TD> <TD>Last 12 Months</TD> <TD>-</TD> <TD>-</TD> <TD>12</TD> </TR> <TR> <TD>202310</TD> <TD>-</TD> <TD>Last 12 Months</TD> <TD>-</TD> <TD>-</TD> <TD>12</TD> </TR> <TR> <TD>202309</TD> <TD>-</TD> <TD>Last 12 Months</TD> <TD>-</TD> <TD>-</TD> <TD>12</TD> </TR> </TBODY> </TABLE> Fri, 15 Nov 2024 20:52:20 GMT https://community.qlik.com/t5/App-Development/How-to-count-the-number-of-closed-months-in-qlik-scripting/m-p/2480906#M100755 ramcena306 2024-11-15T20:52:20Z Re: How to count the number of closed months in qlik scripting? https://community.qlik.com/t5/App-Development/How-to-count-the-number-of-closed-months-in-qlik-scripting/m-p/2492765#M102234 <P>I didnt really understan what you are trying to get here? are looking for months that are past the current month?</P> Thu, 14 Nov 2024 13:57:21 GMT https://community.qlik.com/t5/App-Development/How-to-count-the-number-of-closed-months-in-qlik-scripting/m-p/2492765#M102234 Qrishna 2024-11-14T13:57:21Z