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

Between / subquery /intervalmatch(?) issue

Hi there,

I have a load script issue and I cannot find the solution in Qlik Load language. In SQL this is super easy, with a subquery or someting, but I can't find the right solution.

Here's my case.

I have a table with costprices. When there is a new costprice, there will be a new line and the enddate will be filled out in the old recordline.

StartDateEndDateItemPrice
01-01-201331-12-2013X00013.45
01-01-201431-12-2014X00013.55

Now I also have a orderline table.

OrderdateItemQuantityCostprice
01-04-2013X000112
01-02-2014X00115

In the orderline table, I want to put the costprice of that time. As said, in SQL I would use a subquery or so and in QV I tried things with intervalmatch, but it didn't work out.How can I get the right costprices?

Thanks in advance!

1 Solution

Accepted Solutions

Re: Between / subquery /intervalmatch(?) issue

See attached qvw.


talk is cheap, supply exceeds demand
2 Replies

Re: Between / subquery /intervalmatch(?) issue

See attached qvw.


talk is cheap, supply exceeds demand
Not applicable

Re: Between / subquery /intervalmatch(?) issue

OK, first of all, that works, thank you very much.

Second; I really want to get this .

You are creating a table with orderline info and all the info from the temp table, and after that, you join on startdate, enddate, itemcode, to get the price in. Right?

I struggled with the intervalmatch and the second constraint (item). Thanks, I learned from this.

Community Browser