Issues with Date fields

Fri, 14 Aug 2015 15:37:20 GMT

Hello Everyone,

So I have Three tables:

-Movements (Central table joining the 2 others together)

-Issues

-Receipts

The 3 tables are linked together by keyfields:

- Issues : Request & Batch as IssueKey

-Receipts : Skid & Batch as ReceiptKey

- Movements : Request & Batch as Issue Key / Skid & Batch as Receipt Key

In this way I have my three tables linked together without Synthetic Keys.

The problem is that I want to joined the Date fields of the different tables together but If I do so I will Create synthetic keys because there will be more than 1 field shared between the tables. The problem is that some table have different dates inside and I want to be able to pick one of the Date field to attribute it as the reference for my calendar. ( for example Issues table have Created Date / Issued Date? Shipment Date as Date Fields And I want the reference to be Created Date)

Reference Date Fields :

Movements = Date

Issues= Created Date

Receipts = PR Start Date

I have attached my doc so if you can look at the script editor to see the different fields of the table you can.

Re: Issues with Date fields

Gabriel — Fri, 14 Aug 2015 16:02:39 GMT

Hi,

I think you need a LINK table here.

If you search community there are tons of articles regarding LINK TABLE

topic Issues with Date fields in QlikView

Issues with Date fields

Re: Issues with Date fields