Article Price valid from

Thu, 29 Mar 2012 19:05:45 GMT

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 — Thu, 29 Mar 2012 22:11:52 GMT

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:

Hope this helps,

Stefan

topic Article Price valid from in QlikView