Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

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

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

What I have to do For that??

Thank you...

1 Solution

Accepted Solutions
Not applicable

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

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

11 Replies
Vegar
Not applicable

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

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

Please ekskuse my Norglish and Swenglish typos.
Not applicable

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

You mean to do that in edit script???

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

Thank you...!!

Not applicable

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

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

Vegar
Not applicable

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

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

Please ekskuse my Norglish and Swenglish typos.
Not applicable

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

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

Not applicable

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

pls post the fields of both of ur tables

Not applicable

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

See i have attached the file in the original post yaa

Once and check and temme

Vegar
Not applicable

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

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

Please ekskuse my Norglish and Swenglish typos.
Not applicable

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

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