topic Re: How to create a link feild for sale table and inventory table ? in QlikView

How to create a link feild for sale table and inventory table ?

Wed, 03 Jun 2015 13:10:24 GMT

Hi All

I have create below script for my sales table :-

autonumber( @315:343T & '_' & 'TDSS' ) as desc_Key,

I have create below script for my inventory table :-

autonumber( @12:42T & '_' & 'TDSS' ) as desc_Key,

Now both table are link with desc_key , but not all model are link , for example

3M 11-4945-225-00 CHASIS 17" not able to link ?

Hope some one can share with me why ?

enclosed my QV Doc in my next posting.

Eksa

Re: How to create a link feild for sale table and inventory table ?

giakoum — Wed, 03 Jun 2015 13:22:29 GMT

I believe your issue is the YearMonthDay1, desc and cos fields that are included in the synthetic key you have created in your data model. I cannot understand what you are trying to do, I would guess that you need to connect sales to product via only the product field. Use a productid instead of description I would suggest. What are the YearMonthDay1, desc, cos fields containing?

Re: How to create a link feild for sale table and inventory table ?

Wed, 03 Jun 2015 13:36:52 GMT

if i use YearMonthDay1, i have trouble in my joint because i get the data from third party softwere.YearMonthDay1 is only 1 time value, so i can not use it.

i will use desc to link 2 table.

Re: How to create a link feild for sale table and inventory table ?

giakoum — Wed, 03 Jun 2015 13:38:43 GMT

I am saying exactly the opposite. You are using YearMonthDay1 and desc to join, that is why you have the synthetic key. You should remove that.

Re: How to create a link feild for sale table and inventory table ?

Wed, 03 Jun 2015 13:48:51 GMT

Hi Ioannis,

what i can to do to link 2 these table, if i only have desc for the synthetic key?

Re: How to create a link feild for sale table and inventory table ?

giakoum — Wed, 03 Jun 2015 13:53:03 GMT

Rename the fields you do not want to use for the linking of the tables. Fields with the same name, QlikView is automatically using to link tables

Re: How to create a link feild for sale table and inventory table ?

Wed, 03 Jun 2015 14:22:24 GMT

Thank you very much for your suggestion.