topic Re: Date in QlikView

Date

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

HI All,

I have multiple date fields coming from different table ......

in such kind of scenario can i crate create master calendar and connect all the date fields

Will this work properly ?

Thanks in advance

Re: Date

prma7799 — Thu, 06 Jul 2017 05:16:53 GMT

Yes you can ...

You have to build your data model using Concatenation after that you can take Dates from your data model to create master calendar .

Re: Date

Anil_Babu_Samineni — Thu, 06 Jul 2017 05:17:18 GMT

Yes, It is and Make sure, you must load different times for that dates and concatenate them then use Same Field Name. Off course, Here master calendar can work like charm if you follow same and used same field for that

Re: Date

prma7799 — Thu, 06 Jul 2017 05:21:33 GMT

Like below

DATE:

LOAD

MIN(Date) AS MIN_DATE,

MAX(Date) AS MAX_DATE

Resident (Your concatenate fact table );

LET vDataMax= PEEK('MAX_DATE','0','DATE');

LET vDataMin= PEEK('MIN_DATE','0','DATE');

MasterCalendar:

Script....

Re: Date

smilingjohn — Thu, 06 Jul 2017 06:09:52 GMT

Hi Anil

Thanks for the reply ....

consider an exmaple shown below i have three tables if i connect using Date then there will be sysnthetic keys formed

how do i deal with this ? can u please explian me how do i deal with master calaendar in such scenario?

TableA:

Date

CstmID

Dept

TableB:

Date

CstmID

TableC:

Date

Employee

Re: Date

prma7799 — Thu, 06 Jul 2017 06:23:18 GMT

TRY like this

TableA:

Date

CstmID

Dept

'Dept' as Flag

Concatenate

TableB:

Date

CstmID

'HR' as Flag

Concatenate

TableC:

Date

Employee

'EMP' as Flag

Re: Date

smilingjohn — Thu, 06 Jul 2017 07:01:13 GMT

Hi PM ,

it was just a exampl i will be having many fields in realtime scenario anf concatenating may not be right way of doing this....

Can i have different deffirent madtercalendar ?

I dont understand this how to do

Re: Date

Anil_Babu_Samineni — Thu, 06 Jul 2017 07:09:45 GMT

I worked around 19 Fields which has different source with different data formats. Try this?

Using Multiple Dates With Master Calendar

Re: Date

prma7799 — Thu, 06 Jul 2017 07:13:08 GMT

As Suggested by Mr. Anil please check

Using Multiple Dates With Master Calendar

Re: Date

effinty2112 — Thu, 06 Jul 2017 07:18:52 GMT

Hi John,

You should consider multiple calendars. In the app I use most often I have three, for Order Entry Date, Due Date and Invoice Date. This pic shows part of the data model.

cheers

Andrew

Re: Date

Kushal_Chawda — Thu, 06 Jul 2017 07:20:36 GMT

refer to this

Canonical Date