Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Compare quantity to find Date

Hello,

The title is not very clearan example will be more at least I hope 😉

I encounter a problem for a column calculation Ending month forecast. I have 2 quantities my actual quantities and my forecast quantity I would like to know when (find a date or a number of months) where the sum of these 2 quantities will be equal To Qty to collect.

The Date used for the Forecast quantities (Planned Quantity) = Date_Plan.

The Date used for the actual quantities is Date.

Thank you in advance,

2017-04-28+11_45_45-QlikView+x64+-+[C__Users_epetrini_Desktop_Cust+Part+Price+Amort+TMA.qvw].png

0 Replies