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:
| Fieldname | Formula | Description |
|---|---|---|
| Calendar.Date | date(Field) | Date in the system format, e.g. 01.01.2016 (DD.MM.YYYY) |
| Calendar.Year | year(Field) | Date in the format 2016 (YYYY) |
| Calendar.LYear | year(Field-365) | Previous Year in the format 2015 (YYYY) |
| Calendar.LLYear | year(Field-730) | PrePrevious Year in the format 2014 (YYYY) |
| Calendar.YearTD | if(Field | 1=in year to date full months only in the format (1=true, 0=false) |
| Calendar.YearCTD | if(Field<=today(),1,0) | 1=in year to date in the format (1=true, 0=false) |
| Calendar.LYearTD | if(Field | 1=in last year to date full months only in the format (1=true, 0=false) |
| Calendar.LYearCTD | if(Field<=today()-365,1,0) | 1=in last year to date in the format (1=true, 0=false) |
| Calendar.LLYearTD | if(Field | 1=in previous last year to date full months only in the format (1=true, 0=false) |
| Calendar.LLYearCTD | if(Field<=today()-720,1,0) | 1=in previous last year to date in the format (1=true, 0=false) |
| Calendar.Qtr | quartername(Field) | Date in the Format 1.QTR 2016 |
| Calendar.LQtr | quartername(Field-365) | Date in the Format 1.QTR 2015 |
| Calendar.LLQtr | quartername(Field-720) | Date in the Format 1.QTR 2014 |
| Calendar.QtrTD | if(quarter(Field | 1=quarter to last full month |
| Calendar.LYQtrTD | if(quarter(Field | 1=quarter to previous year last full month |
| Calendar.LLYQtrTD | if(quarter(Field | 1=quarter to previous previous year last full month |
| Calendar.MonthL | monthname(Field) | Date in the format May 2016 (ddd YYYY) |