Date for new calendar year not displaying

chavanrutika — Sat, 16 Nov 2024 17:39:24 GMT

Hi there,

Qlikview report is not displaying the new calendar year in the report

//LET vCalendarYearStart = Year(Today())-2;//
LET vCalendarYearStart = 2016;
SET vDaysInWeekFileName = 'DaysInWeeks_1.1.xlsx';

DaysInWeeks:
NoConcatenate
LOAD
date(WeekStart) as BudgetWeekStartDate,
date(date(WeekStart) + DaysInWeek -1) as BudgetWeekEndDate,
RowNo() as [Budget Week Number]
FROM
[$(vG.ImportPath)\$(vDaysInWeekFileName)]
(ooxml, embedded labels, table is DaysInWeeks) where not IsNull(WeekStart);

dim_CalendarTable:
NoConcatenate
LOAD
%Date_Key,
Date(Date) as Date,

DATE(MonthStart(Date)) as [MonthStart],
WeekDay(Date) as [Week Day Name],
If(month(weekend(Date))= month(Date),div(day(WeekEnd(Date)),7),div(day(Weekend(Date,-1)),7)+1)+1
as WeekNumber,
[Month Year Name],
Month,
[Week of Year],
[Month of Year],
[Month of Year Order],
[Year]
Resident dim_Calendar where [Year] >= $(vCalendarYearStart) and floor(Date) <> 2;
drop Table dim_Calendar;

left join(dim_CalendarTable)
LOAD
Month,
WeekNumber,
count(Date) as [Days In Week (For Month)]
Resident dim_CalendarTable group by
Month,
WeekNumber;
drop Fields WeekNumber;

left JOIN (dim_CalendarTable)
IntervalMatch (Date)
Load Distinct
BudgetWeekStartDate,
BudgetWeekEndDate
Resident DaysInWeeks;

left join(dim_CalendarTable)
LOAD
Distinct
BudgetWeekStartDate,
[Budget Week Number]
Resident DaysInWeeks;
drop Table DaysInWeeks;

//Calendar KPI's
KPI:
LOAD * INLINE [
KPI Number, KPI Name
1, Today
2, WTD
3, MTD
4, QTD
5, YTD
];

join(KPI)
LOAD * INLINE [
Key KPI
Sales
Tonnes
Rate
];

Join (KPI)
Load Distinct [Year]
Resident dim_CalendarTable;

CalObjects_minmaxdates:
NoConcatenate
LOAD
Distinct
min([Date]) AS Min_SaleDate,
max([Date]) AS Max_SaleDate
Resident dim_CalendarTable;

LET vMinDateCalObject = date(Peek('Min_SaleDate',0,'CalObjects_minmaxdates'));
LET vMaxDateCalObject = date(Peek('Max_SaleDate',0,'CalObjects_minmaxdates'));

drop Table CalObjects_minmaxdates;

I am quite new to this .

Cheers,

topic Date for new calendar year not displaying in App Development

Date for new calendar year not displaying