Multiple Date Types With Multiple Table Keys

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

Hi All

below shows the data tables i have used in my dash boards ( See Image No1 ). it has four date types to be considered. and i need one master calendar to link all four dates. i have already been through the posts on using Cannonical date. but my concern is, in this practical scenario i have no prime key to link all four tables.

keys are as follows.

1. Key1 to Budget and Forecast Tables - Company, Buyer

2. Key2 to Forecast and Confirmed Tables - Company, Buyer, ShopNo, RelNo, SeqNo

3. Key3 to Confirmed and Actual Tables - Company, Buyer, OrderNo, LineNo, DelNo

what i need to get as the final out put is shown in the Image No 2. in yellow color i highlighted a data set linked as per the above keys.

and please find attached a sample data set herewith. could someone pls help to solve this matter. thanking in advance.

Image No 1.

Image No 2.

Thank you

topic Multiple Date Types With Multiple Table Keys in QlikView

Multiple Date Types With Multiple Table Keys