topic Re: Date and Datetimestamp asscociation problem while creating Master Calendar in QlikView

Date and Datetimestamp asscociation problem while creating Master Calendar

Wed, 25 Nov 2020 16:16:04 GMT

Hi All

I am facing Dates and datestamp association problem while creating Master Calendar,My sample data having Datetimestamp and just Dates(no timestamp).I would expect output results like EVery 'id' want to show their respective Dates But my calendar showing Null values.Can you please see the below image for your refernce.Here is the attaching sample QVW and sample data.Please guide me how to avoid null values in calendar table.

! !

Re: Date and Datetimestamp asscociation problem while creating Master Calendar

sunny_talwar — Mon, 06 Jun 2016 21:05:01 GMT

Can you check now

Re: Date and Datetimestamp asscociation problem while creating Master Calendar

Mon, 06 Jun 2016 21:42:33 GMT

Hi Sunny,

I can't see nothing here ,did you post anything ?

Re: Date and Datetimestamp asscociation problem while creating Master Calendar

sunny_talwar — Mon, 06 Jun 2016 22:23:53 GMT

Open this link: Re: Date and Datetimestamp asscociation problem while creating Master Calendar

Re: Date and Datetimestamp asscociation problem while creating Master Calendar

sunny_talwar — Tue, 07 Jun 2016 00:16:34 GMT

Here is the script I used:

ABC:

LOAD Date,

Floor(Date) as DateLink,

FROM

[DateTimestamp.xlsx]

(ooxml, embedded labels, table is ABC);

Concatenate(ABC)

LOAD Date,

Floor(Date) as DateLink,

FROM

[DateTimestamp.xlsx]

(ooxml, embedded labels, table is XYZ);

Concatenate(ABC)

LOAD Date,

Floor(Date) as DateLink,

FROM

[DateTimestamp.xlsx]

(ooxml, embedded labels, table is [ CBZ]);

CalendarMaster:

NoConcatenate LOAD

1 as flag,

Date(Date, 'DD/MM/YYYY' ) AS DateLink,

Year(Date) AS Year,

'Q' & Ceil(Month(Date) / 3) AS Quarter,

Month(Date) As Month,

Day(Date) As Day,

WeekDay(Date) as Calendar_Weekday,

Week(Date) As Week;

Load Date(MinDate + IterNo() -1 ) AS Date While (MinDate + IterNo() - 1) <= Num(MaxDate);

Load Floor(Min(Date)) AS MinDate,

Floor(Max(Date)) AS MaxDate

RESIDENT ABC;