- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Suggestion for Calendar.qvs
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.
- Tags:
- Group_Discussions
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Great stuff, thanks for the update Magnus, appreciated. I just need to tweak a few scripts now 😉