Article Price valid from

[#1]

Hello community,

I'm currently struggling with the following requirement:

I have a table orders wit orderid date  articleid
The table article is also linked via articleid to articlevalidprice table

This table looks like:

articleid, validfrom, price

1             27.01.2012    10
1             30.01.2012     11

I need to find out the correct price eg. for a order on 14.02.2012 (-> 11)

How can i impement this?

max

(if(order.date>= articlevalidprice.validfrom,articlevalidprice.validfrom))

this delivers the correct date. I also had a look at this formula

Sum({<articlevalidprice.validfrom ={"$(=max(if(order.date >= articlevalidprice.validfrom ,articlevalidprice.validfrom )))"}>articlevalidprice.price)

but this delievers always the max value per article.

Chart should look like article id, date, price

Thanks in advance for your help.

Kind regards

Aloah

[swuehl]

There are some possible solutions to this, e.g. creating a continuous date range and filling up the price values or using INTERVALMATCH load prefix.

Just having a quick search, I found this discussion which will link a sample of the QV cookbook, always a good start:

http://community.qlik.com/message/73877

Hope this helps,

Stefan