Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i need a master calendar so that all the dates can be captured in single calendar...
i am new to qlikview need clear code for it
Hi,
Please find script below
Sales:
LOAD
Date,
Sales
FROM Sales;
//Get Minimum date
TempSales:
LOAD
Min(Date) AS MinDate
RESIDENT Sales;
//Get and store Minimum date
LET vDateMin = FieldValue('MinDate', 1);
LET vTodayNum = Num(Today());
DROP TABLE TempSales;
SalesDates:
LOAD
($(vDateMin) + (RecNo()) - 1) AS Date,
RecNo() AS DateRecNo
AUTOGENERATE ($(vTodayNum) - $(vDateMin) + 1);
Hope this helps you.
Regards,
Jagan.
Hi,
Please find script below
Sales:
LOAD
Date,
Sales
FROM Sales;
//Get Minimum date
TempSales:
LOAD
Min(Date) AS MinDate
RESIDENT Sales;
//Get and store Minimum date
LET vDateMin = FieldValue('MinDate', 1);
LET vTodayNum = Num(Today());
DROP TABLE TempSales;
SalesDates:
LOAD
($(vDateMin) + (RecNo()) - 1) AS Date,
RecNo() AS DateRecNo
AUTOGENERATE ($(vTodayNum) - $(vDateMin) + 1);
Hope this helps you.
Regards,
Jagan.