Finding Values based on date

[#1]

Hi,

I have a data in which there are several purchase orders (POs) with item numbers, quantity and expected receipt date.

Now i need to find out per item number first three expected receipt dates which should be greater than today i.e. should be in future. Besides that I also need to find out how much quantity will be received for that item number on these dates.

I have calculated the first three expected receipt dates in future per item but the quantity for these dates is giving me some headache.

I have attached herewith the excel file containing source data plus the Qlikview file in which I have calculated the first three dates.

I have used below formulas for calculating dates

!

I expect below outcome:

Request you to help me with the calculation.

[tresesco]

PFA

Expr1:  =sum(If(Date1=[PDPSDJ - Date], [PDUOPN - Quanity]))

[Kushal_Chawda · Accepted solution]

is this the same thread?

Finding values based on date

[#4]

yes but i am trying to do it on back end