Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
paolojolly
New Contributor III

join table

hi,

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

I have two table, one with document date and price

                       

doc dateprize
01/02/20141
04/04/20142
15/05/20142,2
05/06/20142,5

and another with quotation date and quotation value

                           

quotation
  date
value quotation
01/01/20145
15/02/20146
03/03/20147
03/04/20148
05/05/20149

I need to join the two tables in order to obtain

doc dateprize last value   quotation     with date <= doc date
01/02/201415
04/04/201428
15/05/20142,29
05/06/20142,5

9

can someone help me?

Thanks

Tags (2)
1 Solution

Accepted Solutions

Re: join table

Hi,

one solution could be:

QlikCommunity_Thread_143406_Pic1.JPG.jpg

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

3 Replies

Re: join table

Hi,

one solution could be:

QlikCommunity_Thread_143406_Pic1.JPG.jpg

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

paolojolly
New Contributor III

Re: join table

Thank you very much!

Re: join table

You're welcome

Regards

Marco

Community Browser