Month Year to Month Number

[Anonymous]

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!

[stigchel]

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

[sunny_talwar · Accepted solution]

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

[stigchel]

For master calendar scripts see for example

Better Calendar Scripts | Qlikview Cookbook

[Anonymous]

Thank you Sunny! Worked perfectly.