A fast way to do this is to create a table in excel containing the next fields... master_date and alternative_month, fill master_date field with all dates of the year and fill alternative_month with the corresponding new value of month then load this excel into qlikvew and make a left join to the master calendar with this new table , now your master_calendar will have a new field called alternative_month where you are going to have this new month that you want, regards!
If you have fields DateId and Day in your calendar (table Date), add this script:
LEFT JOIN (Date) LOAD
'Month ' &
num(month(addmonths(DateId,-1)))) as ModifiedMonth
And, see attached.
ModifiedMonth.qvw 140.8 K