Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
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