hello everybody !!
I have just started to work with Qlikviw 8.5, and i have a problem with dates !!!
in table calendar i create a temporary calendar and then i drop it :
TempCalendar:
LOAD
RESIDENT
fact
ORDER BY DATE;
DISTINCT DATE
AS DATE
Calendar:
LOAD
DATE,
Year
(DATE) AS Annee,
Month
(DATE) AS Mois,
num
(Month(DATE)) AS NumMois,
num
(Week(DATE),00) AS Semaine, ..........
..........
RESIDENT
DROP
but the problem that an error tell me thet there is no table TemCalendar !!!!!!
so what is the the problem??
thank you for your help
TABLE TempCalendar; TempCalendar;
