topic Re: Month Year to Month Number in QlikView

Month Year to Month Number

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I'm wondering if you can change month year to month numbers for consecutive years. I want the month numbers for the last 3 years with January 2015 starting as '1'. Is it possible to go past 12 months in Qlikview?

For example,

month_year	month_number
Jan-2015	1
Feb-2015	2
Mar-2015	3
Apr-2015	4
...
Jan-2017	25
Feb-2017	26

Thanks!

Re: Month Year to Month Number

stigchel — Tue, 27 Feb 2018 17:33:43 GMT

Sure why not, but instead of using date functions create a dual yourself. So in the 'normal' calendar create script where you iterate between a min and max date load a field like

Dual(Date(TempDate,'MMM-YYYY',Rowno()) as MonthYear

Re: Month Year to Month Number

sunny_talwar — Tue, 27 Feb 2018 17:37:28 GMT

Another option is to just use AutoNumber(month_year) as month_number in your mast calendar table where the table is sorted by date or month_year in ascending order

Re: Month Year to Month Number

stigchel — Tue, 27 Feb 2018 17:48:50 GMT

For master calendar scripts see for example

Better Calendar Scripts | Qlikview Cookbook

Re: Month Year to Month Number

Anonymous — Tue, 27 Feb 2018 18:43:19 GMT

Thank you Sunny! Worked perfectly.