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

Left Join in Load

Hi,

I have two tables that i want to join together while performing a calculation.

Table 1:

Record ID      Date               ItemID          Quantity     

1                    3/1/2012       A                  3

Table 2:

Effective Date     End Date     ItemID          Price

1/1/2012            12/31/2012     A               $10.00

Desired Result:

Record ID     Date               ItemID     Quantity      Charge (Price*Quality)

1                  3/1/2012            A          3               $30.00

How would I do this in a load statement?

Tags (2)
1 Reply
Highlighted

Re: Left Join in Load

HI,

     Use interval match function..

You can refer about in reference manual or  below posts: 

     http://community.qlik.com/message/192808#192808

     http://community.qlik.com/message/222133#222133

Hope it helps

Community Browser