Price based on range dates

jorditorras · ‎2021-07-05

Dear Gurus,

I’m working in a Purchasing Application in QlikSense and there’s one section that I don’t know how to manage…

I have two tables similar as the one of the screenshot:

I want to get the “InfoRecord Price” for each “Order Number” considering:

Each “InfoRecord Code” of the INFOREC TABLE has different ranges of dates (Date Start-Date End) and therefore different ”Inforecord Prices”
The Price I need for each “Order Number” should be the one which his “Order Date” is between the range “Date Start – Date End” of the INFOREC TABLE.

Any idea how to handle it?

Thanks in advance!

kaushiknsolanki · ‎2021-07-05

Hi @jorditorras what you need is the "Intervalmatch" function.

Check out this.

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!