Find record between active and disable date

Tue, 21 Jun 2011 14:55:09 GMT

Hi!

I am wondering about a problem that came up just recently. I have a table contaning conversion data, converting an items' quantity based on a multiplier. For example item 1 could have a sold quantity of 10 bags to a customer, leading to a qty of 10 (duh! ). Thing is that each bag contains 100 pieces, but after a year the bag could be changed to a larger and contain 200 instead. I want to find these 100 or 200 depending on the date of the order and the active/disable date of the conversion record.

I have attached a simple example to review. What I want to do is to multiply the Qty with the correct conversion based on in between which active/disable date dates the order date is.

Robert

Re: Find record between active and disable date

nagaiank — Tue, 21 Jun 2011 16:45:12 GMT

You need to add the field 'Conversion' in your Order table. As the value of 'Conversion' depends on the order date, use IntervalMatch to find the Conversion value.

Modified qvw file with IntervalMatch added is attached.

Hope this helps.

topic Re: Find record between active and disable date in QlikView

Find record between active and disable date

Re: Find record between active and disable date