Master Qlik Script Template

Master Qlik Script Template.qvs

/*  Master script template!  */

// ===============================================
//                      MAPPING
// ===============================================

[mapping]:
Mapping LOAD * Inline [
old, new

];


// ===============================================
//                      SUB
// ===============================================

SUB Load

	[]:
    LOAD
    	1
    AutoGenerate 1;

END SUB


SUB Store
	Store [] into 'lib://Space:DataFiles/file.qvd'(QVD);
END SUB


SUB Load_QVD
	[]: LOAD * FROM 'lib://Space:DataFiles/file.qvd'(QVD);
END SUB


// ===============================================
//                      LOAD
// ===============================================

/*  Table  */
Call Load
Call Store
// Call Load_QVD


// ===============================================
//                      ETL
// ===============================================

Qualify *;
// Unqualify [];

[t]:
NoConcatenate LOAD
    []
  , []
  , []
Resident [];

Unqualify *;

Drop Table [];
Rename Table [t] to [];



// ===============================================
//                      CALENDAR
// ===============================================

cal:
DECLARE FIELD DEFINITION TAGGED '$date'
   Parameters
      first_day_of_week = 6
   Fields
      Year($1) As Year Tagged ('$numeric'),
      Month($1) as Month Tagged ('$numeric'),
      MonthName($1) as MonthYear Tagged ('$numeric'),
      Date($1) as Date Tagged ('$date'),
      Dual( Date(WeekStart($1, 0, first_day_of_week), 'M/D/YY') & ' - ' & Date(WeekEnd($1, 0, first_day_of_week), 'M/D/YY'), WeekStart($1, 0, first_day_of_week)) as Week Tagged ('$numeric'),
      Weekday($1) as Weekday Tagged ('$numeric')
;

DERIVE FIELDS FROM FIELDS [Date] USING cal;