topic AW:Connecting multiple date fields together in QlikView

Connecting multiple date fields together

Anonymous — Fri, 27 Aug 2010 11:09:47 GMT

Hi Experts

I have imported 10 tables in qlikview and each of these tables have got Year, Month and Product_ID. Now I want to join these tables together with Year Month and Product_Key wihtout creating any senthetic key.

So at the end I can view all the data through months and year.

Can someone help me on this please?

Thanks in advance

Waqas

AW:Connecting multiple date fields together

brenner_martina — Fri, 27 Aug 2010 11:16:42 GMT

Hi, Waqas,

it is very simple, enter in all tables this and comment in all tables except one the fields Product_Key, year ans month:

Product_Key & '/' & Year & '/' & Month as Keyfield

AW:Connecting multiple date fields together

Anonymous — Fri, 27 Aug 2010 11:28:31 GMT

Thanks so much Martina for your prompt reply.

Do you mean to creat concatenated key?

Product_Key & '/' & Year & '/' & Month as Keyfield

I got this bit but what you mean by "except one the fields Product_Key, year ans month:" ?

Thanks

Waqas

Hi, Waqas,

it is very simple, enter in all tables this and comment in all tables except one the fields Product_Key, year ans month:

Product_Key & '/' & Year & '/' & Month as Keyfield

best greetings

Martina Brenner
Dreamteam Solutions, Munich

AW:Connecting multiple date fields together

Anonymous — Fri, 27 Aug 2010 11:37:10 GMT

also If I have KeyField(concatenated key) in all the tables then don't you think every single table will try to associate with every other table which will have KeyField? hence there will be synthetic key(s)?