Finding Values based on date

Wed, 13 Sep 2017 06:58:24 GMT

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.

Re: Finding Values based on date

tresB — Wed, 13 Sep 2017 07:25:42 GMT

PFA

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

Re: Finding Values based on date

Kushal_Chawda — Wed, 13 Sep 2017 07:29:05 GMT

is this the same thread?

Finding values based on date

Re: Finding Values based on date

Wed, 13 Sep 2017 07:50:01 GMT

yes but i am trying to do it on back end

topic Re: Finding Values based on date in QlikView

Finding Values based on date

Re: Finding Values based on date

Re: Finding Values based on date

Re: Finding Values based on date