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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
deepika_gohil
Contributor
Contributor

Application is not running on the server

The following error occurred:
Table 'tempDateTimeList' not found
 
The error occurred here:
TimeDIM: LOAD DISTINCT DateTime, Year(DateTime) as Year, MonthName(DateTime) as Month, WeekStart(DateTime) as [Week Beginning], date(dayname(DateTime),'MMM-DD') as Day, WeekDay(DateTime) as Weekday, makedate(year(DateTime),month(DateTime),day(DateTime)) as Date, Hour(DateTime)&':00' as Hour, ApplyMap('hour_temp',Hour(DateTime)&':00' ) as hour_sort, Minute(DateTime) as [Minute of Hour], timestamp(floor(DateTime,1/(24)),'MMM-DD hh:00') as [Hour Timeline], If(DateTime>=43650.77912037,1) AS last7days, If(DateTime>=43643.77912037,1) AS last14days, If(DateTime>=43629.77912037,1) AS last28days, If(DateTime>=43567.77912037,1) AS last90days resident tempDateTimeList
Labels (1)
1 Reply
Sue_Macaluso
Former Employee
Former Employee

@deepika_gohil  What product are you using?

Did you find a solution to your question? Mark the solution as accepted : and if you found it useful, press the like button!