Suggestion for Calendar.qvs

[qliknerd]

In the Calendar script there is a function to add fiscal months, the output of which currently displays Fiscal Month in the format:

1. Apr

2. May

3. Jun etc.

Could the default be without the number prefix, so instead of

Dual(Num(Month(AddMonths([$(vL.DateFieldLinkName)],$(vL.MonthsLeftFiscalDates)))) & '. ' & Month([$(vL.DateFieldLinkName)]),Num(Month(AddMonths([$(vL.DateFieldLinkName)],$(vL.MonthsLeftFiscalDates))))) AS [$(vL.CalendarTableName) Fiscal Month],

It defaults to:

Dual(Month([$(vL.DateFieldLinkName)]), Num(Month(AddMonths([$(vL.DateFieldLinkName)],$(vL.MonthsLeftFiscalDates))))) AS [$(vL.CalendarTableName) Fiscal Month],

This way, Fiscal Month outputs like the normal calendar, but will still retain the appropriate order:

Apr

May

Jun etc.

[Magnus_Berg]

Hi Ian, agree that in seem to be better. The code is not ours from the start, will need to check so that no one uses the 1. Thx

[Magnus_Berg · Accepted solution]

Hi Ian, the CalendarGen function is now changed according to your suggestion still version 1.5.0

Qlik Deployment Framework Deploy Tool

Best regards

Magnus

[qliknerd]

Great stuff, thanks for the update Magnus, appreciated. I just need to tweak a few scripts now 😉