Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Thank you very much!
You're welcome
Regards
Marco