topic Re: Multiple date fields in single table in QlikView

Multiple date fields in single table

divya_anand — Sun, 07 Aug 2016 12:17:19 GMT

Hi,

I have a single table data with 4 date fields (Created, Assigned, Target, Completed). how can I deal with this in connecting to the Master Calendar?

Thank you.

Re: Multiple date fields in single table

marcus_sommer — Sun, 07 Aug 2016 13:58:24 GMT

Have a look on this:

Canonical Date

Why You sometimes should Load a Master Table several times‌

- Marcus

Re: Multiple date fields in single table

Mon, 08 Aug 2016 06:13:34 GMT

Hi,

When u have multiple date fields use conicaldates

Re: Multiple date fields in single table

avinashelite — Mon, 08 Aug 2016 06:29:04 GMT

create a LINK table , to connect for the Master calendar.

Try like this :

Master:

LOAD

Created,

Assigned,

Target,

Completed,

Key

....

LINK:

LOAD Key,

Created as Date_Key

resident

Master;

LOAD Key,

Assigned as Date_Key

resident

Master;

LOAD Key,

Target as Date_Key

resident

Master;

LOAD Key,

Completed as Date_Key

resident

Master;

Calendar:

LOAD Date as Date_Key,

.....

NOTE: keep all the dates in same format

Hope this helps you .