Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
ramcena306
Creator II
Creator II
‎2024-09-11 03:51 AM

How to count the number of closed months in qlik scripting?

Hello Team,

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.

Fiscal_Month Fiscal_Year Last 12 months Last 16 Months last 24 months closed Months
202110 2022 2022 2022 2022 12
202111 2022 2022 2022 2022 12
202112 2022 2022 2022 2022 12
202201 2022 2022 2022 2022 12
202202 2022 2022 2022 2022 12
202203 2022 2022 2022 2022 12
202204 2022 2022 2022 2022 12
202205 2022 2022 2022 2022 12
202206 2022 2022 2022 2022 12
202207 2022 2022 2022 2022 12
202208 2022 2022 2022 2022 12
202209 2022 2022 2022 2022 12
202210 2023 2023 2023 2023 12
202211 2023 2023 2023 2023 12
202212 2023 2023 2023 2023 12
202301 2023 2023 2023 2023 12
202302 2023 2023 2023 2023 12
202303 2023 2023 2023 2023 12
202304 2023 2023 2023 2023 12
202305 2023 2023 2023 2023 12
202306 2023 2023 2023 2023 12
202307 2023 2023 2023 2023 12
202308 2023 2023 2023 2023 12
202309 2023 2023 2023 2023 12
202310 2024 2024 2024 2024 11
202311 2024 2024 2024 2024 11
202312 2024 2024 2024 2024 11
202401 2024 2024 2024 2024 11
202402 2024 2024 2024 2024 11
202403 2024 2024 2024 2024 11
202404 2024 2024 2024 2024 11
202405 2024 2024 2024 2024 11
202406 2024 2024 2024 2024 11
202407 2024 2024 2024 2024 11
202408 2024 2024 2024 2024 11
202408 - - - Last 24 Months 24
202407 - - - Last 24 Months 24
202406 - - - Last 24 Months 24
202405 - - - Last 24 Months 24
202404 - - - Last 24 Months 24
202403 - - - Last 24 Months 24
202402 - - - Last 24 Months 24
202401 - - - Last 24 Months 24
202312 - - - Last 24 Months 24
202311 - - - Last 24 Months 24
202310 - - - Last 24 Months 24
202309 - - - Last 24 Months 24
202308 - - - Last 24 Months 24
202307 - - - Last 24 Months 24
202306 - - - Last 24 Months 24
202305 - - - Last 24 Months 24
202304 - - - Last 24 Months 24
202303 - - - Last 24 Months 24
202302 - - - Last 24 Months 24
202301 - - - Last 24 Months 24
202212 - - - Last 24 Months 24
202211 - - - Last 24 Months 24
202210 - - - Last 24 Months 24
202209 - - - Last 24 Months 24
202408 - - Last 16 Months - 16
202407 - - Last 16 Months - 16
202406 - - Last 16 Months - 16
202405 - - Last 16 Months - 16
202404 - - Last 16 Months - 16
202403 - - Last 16 Months - 16
202402 - - Last 16 Months - 16
202401 - - Last 16 Months - 16
202312 - - Last 16 Months - 16
202311 - - Last 16 Months - 16
202310 - - Last 16 Months - 16
202309 - - Last 16 Months - 16
202308 - - Last 16 Months - 16
202307 - - Last 16 Months - 16
202306 - - Last 16 Months - 16
202305 - - Last 16 Months - 16
202408 - Last 12 Months - - 12
202407 - Last 12 Months - - 12
202406 - Last 12 Months - - 12
202405 - Last 12 Months - - 12
202404 - Last 12 Months - - 12
202403 - Last 12 Months - - 12
202402 - Last 12 Months - - 12
202401 - Last 12 Months - - 12
202312 - Last 12 Months - - 12
202311 - Last 12 Months - - 12
202310 - Last 12 Months - - 12
202309 - Last 12 Months - - 12
Labels (3)
Labels
336 Views
1 Reply
Qrishna
Master
Master
‎2024-11-14 08:57 AM

I didnt really understan what you are trying to get here? are looking for months that are past the current month?

231 Views
0 Likes