Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

problem with table calendar !!

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;





1 Reply
Not applicable
Author

Hi,

Your script has not been Pasted properly on your last post. can you pl re - paste the script again?

- Peterson.