Date format problem

GuillaumeRUE — Wed, 07 Aug 2019 11:25:02 GMT

Hello,

I created those two tables :

MISSION_2: LOAD ID_ORDRE, AGV, Timestamp(DATE_ORDRE,'DD/MM/YYYY hh:mm') as Id_Date_AGV, TYPE_ORDRE, POIDS_TRANSPORTE

CalendarTemp: LOAD DayStart(TimeStamp($(varMinDate) + (RecNo()/60/24) + (IterNo() -1))) AS AddedDate, // Use this one as date TimeStamp($(varMinDate) + (RecNo()/60/24) + (IterNo() -1),'DD/MM/YYYY hh:mm') AS AddedTimeStamp AUTOGENERATE 1339 WHILE Num($(varMinDate) + IterNo() -1) <= Num($(varMaxDate)); TIME_CALENDAR: LOAD AddedTimeStamp as Id_Date_AGV, Date(Floor(AddedTimeStamp)) as Date_AGV, Year(AddedTimeStamp) as Annee, Month(AddedTimeStamp) as Mois, Day(AddedTimeStamp) as Jour, Week(AddedTimeStamp) as Semaine, Hour(AddedTimeStamp) as Heure, Minute(AddedTimeStamp) as Minute Resident CalendarTemp Order By AddedTimeStamp ASC;

But not all data from MISSION_2 is linked to the calendar, only few rows, any idea?

Re: Date format problem

m_woolf — Wed, 07 Aug 2019 12:44:03 GMT

I think you need:

Date(Floor(DATE_ORDRE)) as Id_Date_AGV,

Re: Date format problem

Brett_Bleess — Mon, 26 Aug 2019 19:17:35 GMT

Couple of Design Blog posts for you that may help if you are still working on things:

https://community.qlik.com/t5/Qlik-Design-Blog/The-Master-Calendar/ba-p/1471527

https://community.qlik.com/t5/Qlik-Design-Blog/Canonical-Date/ba-p/1463578

Regards,
Brett

topic Re: Date format problem in QlikView

Date format problem

Re: Date format problem

Re: Date format problem