Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ecabanas
Creator II
Creator II

How to do this

I have a table with the product cost(A) and another table with the cost from invoices(B).

I would like to find from the A table the item cost and find the last invoice cost from B table

Item_lastInvoice.png

Anyone knows how to do this?

Many thank's

Eduard

1 Solution

Accepted Solutions
JoaquinLazaro
Partner - Specialist II
Partner - Specialist II

Hi Eduard:

No arrow for the 4444 invoice !!!!

The second line in the real cost line has an arrow to the 3333 invoice.

Do I miss anything ?

Joaquín

View solution in original post

19 Replies
Not applicable

Hi,

Could you please elaborate your requirement.

Anonymous
Not applicable

Hi ,

So what I understand you want to get the invoice from Table B,  with same cost in Table A (Latest Date)

Then the last Cost 175 should attach with 1111 invoice no. correct ??

or you are considering any other logic ??

Thanks

BKC

Not applicable

Hi,

By reading your query what I can understand is you have to map invoice of table B to Table 1having the same cost & same ItemID.Just applymap it if that the issue.But i guess the requirement is something else.

ecabanas
Creator II
Creator II
Author

Hi Balkumar,

I just added the example. I would like to add a for every fiel from A table the lattest invoice cost for each row.

Many thank's

Item_lastInvoice.png

JoaquinLazaro
Partner - Specialist II
Partner - Specialist II

Hi Eduard:

RealCost:

Load ....

       Trim(ItemID) & '+' & Cost as KeyRC

InoviceCost:

Left join (RealCost)

Load ....

       Trim(ItemID) & '+' & Cost as KeyIC




You should manage the field names in order to avoid syntetic keys !!!


Hope this helps you.

Joaquín

JoaquinLazaro
Partner - Specialist II
Partner - Specialist II

Hi Eduard:

Look at the attached app.

But .... If the real cost fo AA 01/03/2015 is 1.75 the invoice is 1111

Regards

Joaquín

ecabanas
Creator II
Creator II
Author

Hi Joaquin,

I attached your answer, but did not solve the problem.

For example the second line in cost table is linked with invoice line "11111" and has to be linked to invoice "4444"

Many thank's for your patience

Eduard

JoaquinLazaro
Partner - Specialist II
Partner - Specialist II

Hi Eduard:

No arrow for the 4444 invoice !!!!

The second line in the real cost line has an arrow to the 3333 invoice.

Do I miss anything ?

Joaquín

ecabanas
Creator II
Creator II
Author

SOrry Joaquin, you are right, my falt!!

MAAANY thank's for your help

Regards

Eduard