topic Re: Suggestion for Calendar.qvs in Archived Groups

Suggestion for Calendar.qvs

qliknerd — Tue, 22 Jul 2025 17:59:49 GMT

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.

Re: Suggestion for Calendar.qvs

Magnus_Berg — Fri, 21 Aug 2015 08:45:22 GMT

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

Re: Suggestion for Calendar.qvs

Magnus_Berg — Mon, 07 Sep 2015 11:25:36 GMT

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

Re: Suggestion for Calendar.qvs

qliknerd — Mon, 07 Sep 2015 17:34:01 GMT

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