topic Re: Issues with joining Date Fields in QlikView

Issues with joining Date Fields

Wed, 12 Aug 2015 09:36:59 GMT

Hi Everyone,

I have 3 tables and in each of them I have a date field.

I have defined in each of my table days, weeks and months thanks to the functions ;

Table A:

X & Y as IssueKey,

DateA,

Day(DateA) as Day,

Week(DateA) as Week

Month(DateA) as Month

Table B:

X&Y as IssueKey,

A & Z as Receipt Key

DateB,

Day(DateB) as Day,

Week(DateB) as Week

Month(DateB) as Month

Table C:

A & Z as ReceiptKey,

DateC,

Day(DateC) as Day,

Week(DateC) as Week

Month(DateC) as Month

As you can notice I have already create common field keys to bind my 3 tables together ( IssueKey and ReceiptKey) and I would like also the dates from those tables to be all connected

The problem is that this lead to the creation of synthetic keys because of the shared columns of each table (Day,week, month).
Do You know any way to join those 3 fields in all my tables without creating synthetic keys ?

Thank you very much

Alexandre

Re: Issues with joining Date Fields

sunny_talwar — Wed, 12 Aug 2015 09:40:27 GMT

Are you explicitly joining the three tables using the Join statement? If not you might want to create a master calendar which is connected to all the three tables on date and in that master calendar table you can do all your day, month, year calculations.

HTH

Best,

Sunny

Re: Issues with joining Date Fields

Wed, 12 Aug 2015 10:26:19 GMT

Hello

My tables are joined with a key already and I thought the mastercalendar can only be generated for one date field ?

Re: Issues with joining Date Fields

Fri, 30 Oct 2015 10:06:59 GMT

Please can you give an example of adding those dates to the master calender