Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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

Tags (1)
1 Solution

Accepted Solutions
Highlighted
Specialist II
Specialist II

Re: How to do this

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
Highlighted
Not applicable

Re: How to do this

Hi,

Could you please elaborate your requirement.

Highlighted
Specialist II
Specialist II

Re: How to do this

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

Highlighted
Not applicable

Re: How to do this

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.

Highlighted
Creator II
Creator II

Re: How to do this

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

Specialist II
Specialist II

Re: How to do this

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

Highlighted
Specialist II
Specialist II

Re: How to do this

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

Highlighted
Creator II
Creator II

Re: How to do this

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

Highlighted
Specialist II
Specialist II

Re: How to do this

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

Highlighted
Creator II
Creator II

Re: How to do this

SOrry Joaquin, you are right, my falt!!

MAAANY thank's for your help

Regards

Eduard