topic join table in QlikView

join table

paolojolly — Mon, 24 Nov 2014 23:04:45 GMT

hi,

i'm new in qlik view and i have the following problem.

I have two table, one with document date and price

doc date	prize
01/02/2014	1
04/04/2014	2
15/05/2014	2,2
05/06/2014	2,5

and another with quotation date and quotation value

quotation date	value quotation
01/01/2014	5
15/02/2014	6
03/03/2014	7
03/04/2014	8
05/05/2014	9

I need to join the two tables in order to obtain

doc date	prize	last value quotation with date <= doc date
01/02/2014	1	5
04/04/2014	2	8
15/05/2014	2,2	9
05/06/2014	2,5	9

can someone help me?

Thanks

Re: join table

MarcoWedel — Mon, 24 Nov 2014 23:56:51 GMT

Hi,

one solution could be:

tabPrice:
LOAD *
FROM [http://community.qlik.com/thread/143406] (html, codepage is 1252, embedded labels, table is @1);

tabValue:
LOAD *
FROM [http://community.qlik.com/thread/143406] (html, codepage is 1252, embedded labels, table is @2);

tabLink:
IntervalMatch ([doc date])
LOAD [quotation date],
    Alt(Previous([quotation date]),Today()) as [prev quotation date]
Resident tabValue
Order By [quotation date] desc;

hope this helps

regards

Marco

Re: join table

paolojolly — Tue, 25 Nov 2014 11:06:56 GMT

Thank you very much!

Re: join table

MarcoWedel — Tue, 25 Nov 2014 11:09:56 GMT

You're welcome

Regards

Marco