Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
May 18th 10AM ET, Live Chat, bring your QlikView questions. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
emilienp
Contributor III
Contributor III

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