topic Re: Calculate New date in QlikView

Calculate New date

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello! I hope someone can help me who's expert in looping. Not sure what function to use on this kind of calculation ...I was thinking of peek but looks like it won't work but looping will do the job.

I'm trying to calculate a proposed new date for orders that's based on the Supply date and Inventory Qty. If there are orders with no invtry then delivery date + LT... The encircled column is my desired output.

ex. 1st line order qty is 1498 with delivery date 04/15/17 but since invtry will be available on 4/25/17 1548, Thus, new proposed date is 4/25/17.

2nd line, since next available supply 199 is not enough to suffice the order qty, 250, then pick the next line for the date 5/1...

Thank you in advance.

Re: Calculate New date

Anil_Babu_Samineni — Fri, 14 Apr 2017 02:14:58 GMT

1) Is this is single table, I mean data source

2) This is possible Please share sample data

Re: Calculate New date

Anonymous — Fri, 14 Apr 2017 17:21:12 GMT

Hi! Anil,

1. Yes, this is a single table

2. Pls. see attached sample...Btw, just make some corrections from my previous post...IF there is no supply, it will be enter date (not delivery date) + LT.

Tks.