Global Calendar

Having a well structured calender within your qlikview app allows you to build faster charts and reports. Speak to your internal customers about their report layouts and you’ll see that most people have a common sense on how to combine data over time.

Below you will find a list of fields which we recommend to add it to your default calendar.

Definition:

FieldnameFormulaDescription
Calendar.Datedate(Field)Date in the system format, e.g. 01.01.2016 (DD.MM.YYYY)
Calendar.Yearyear(Field)Date in the format 2016 (YYYY)
Calendar.LYearyear(Field-365)Previous Year in the format 2015 (YYYY)
Calendar.LLYearyear(Field-730)PrePrevious Year in the format 2014 (YYYY)
Calendar.YearTDif(Field1=in year to date full months only in the format (1=true, 0=false)
Calendar.YearCTDif(Field<=today(),1,0)1=in year to date in the format (1=true, 0=false)
Calendar.LYearTDif(Field1=in last year to date full months only in the format (1=true, 0=false)
Calendar.LYearCTDif(Field<=today()-365,1,0)1=in last year to date in the format (1=true, 0=false)
Calendar.LLYearTDif(Field1=in previous last year to date full months only in the format (1=true, 0=false)
Calendar.LLYearCTDif(Field<=today()-720,1,0)1=in previous last year to date in the format (1=true, 0=false)
Calendar.Qtrquartername(Field)Date in the Format 1.QTR 2016
Calendar.LQtrquartername(Field-365)Date in the Format 1.QTR 2015
Calendar.LLQtrquartername(Field-720)Date in the Format 1.QTR 2014
Calendar.QtrTDif(quarter(Field1=quarter to last full month
Calendar.LYQtrTDif(quarter(Field1=quarter to previous year last full month
Calendar.LLYQtrTDif(quarter(Field1=quarter to previous previous year last full month
Calendar.MonthLmonthname(Field)Date in the format May 2016 (ddd YYYY)

Schreibe einen Kommentar