How to copy field of one table to other table??

[#1]

So here i want access between CustomerName and ItemID...

What I have to do For that??

Thank you...

[Vegar]

You could right click QUANTITY-expression in Sales Table and press copy.

Go to Dealers table and press paste in the expressions overview.

Best regards

Vegar Lie Arntsen

QlikView consultant at egbs consulting ab

Blog (in Swedish): bi-effekten.se

[#3]

You mean to do that in edit script???

could you explain with an example if possible..!!

Thank you...!!

[#4]

u need to join on the common field Sales table & Dealers tables

[Vegar]

I'm sorry I missunderstood your question. Tought it was a chart design question.

As qlik_techie says: You need a field that links the Sales and Dealers table together.

Best regards

Vegar Lie Arntsen

QlikView consultant at egbs consulting ab

Blog (in Swedish): bi-effekten.se

[#6]

I am sorry I dint get you. How to do that??

[#7]

pls post the fields of both of ur tables

[#8]

See i have attached the file in the original post yaa

Once and check and temme

[Vegar]

How are you going to connect the tables? Do you know who bought what? Seems like your are missing a link between the tables. Do you have any tables with both customerID and InvoiceID in it?

Best regards

Vegar Lie Arntsen

QlikView consultant at egbs consulting ab

Blog (in Swedish): bi-effekten.se

[#10 · Accepted solution]

i think while creating qvds from ur source data u have missed the some field which wud link the two tables