search

RobWunderlich / Qlikview-Components

A library for common Qlikview Scripting tasks
197 stars 99 forks source link

Update Qvc_Calendar.qvs #49

Closed M2r4Miller closed 7 years ago

M2r4Miller commented 8 years ago

Added new set variables for RollingN months, Previous FULL MonthN (parameterized) gives the full month x number of months back. Previous FULL Month, gives entire last month, not just last month-to-date.

Added new "MonthName" field to calendar which contains the full name of the month, eg "January" vs. "Jan". This is a Dual() as well. Changed existing "Month" field to a Dual() so months will always sort correctly for Annual and Fiscal calendars.

Moved all Calendar Set Variable generation to separate routine. Created two new calendar generation routines: Qvc.CalendarNoFill(...) Qvc.CalendarFromFieldNoFill(...)

These new routines create calendars directly from a field (resident table only) and work the same as the existing routines, except only dates that exist in the data is included in the generated calendar. Missing dates in the data are not filled in by these routines.

RobWunderlich commented 7 years ago

I've got this merged and am testing. What do you think of the idea that instead of separate routines for NoFill, if instead we use a config variable to indicate NoFill? I think it may ease the maint and doc.