I am working in a a straight table and I need help figuring out how to make the last column in Qlikview. I have created the table in excel using the following formula:
=SUMIFS(C:C,A:A,A2,D:D,"<"&D2)
sum order quantity if it is the same part number and the Promised ship date is less than given promised ship date
| Part Number | Qty on Hand | order quantity | Promised ship date | consumed |
| Part A | 50 | 10 | 1/1/2020 | 0 |
| Part A | 50 | 10 | 2/1/2020 | 10 |
| Part A | 50 | 10 | 3/1/2020 | 20 |
| Part B | 30 | 10 | 1/1/2020 | 0 |
| Part B | 30 | 10 | 2/1/2020 | 10 |
| Part B | 30 | 10 | 3/1/2020 | 20 |
| Part B | 30 | 10 | 4/1/2020 | 30 |
The formula I have in Qlikview currently only sums the order quantity based on the part number:
sum(Total <WW_Item_Number__SDLITM> Quantity_Ordered__SDUORG)
How would I add the date aspect?
