topic Compare quantity to find Date in QlikView https://community.qlik.com/t5/QlikView/Compare-quantity-to-find-Date/m-p/1355157#M416000 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>The title is not very clearan example will be more at least I hope <span class="lia-unicode-emoji" title=":winking_face:">😉</span></P><P>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.</P><P>The Date used for the Forecast quantities (Planned Quantity) = Date_Plan.</P><P>The Date used for the actual quantities is Date.</P><P>Thank you in advance,</P><P><IMG alt="2017-04-28+11_45_45-QlikView+x64+-+[C__Users_epetrini_Desktop_Cust+Part+Price+Amort+TMA.qvw].png" class="jive-image image-1" src="/legacyfs/online/161984_2017-04-28+11_45_45-QlikView+x64+-+[C__Users_epetrini_Desktop_Cust+Part+Price+Amort+TMA.qvw].png" style="height: 221px; width: 620px;" /></P></BODY></HTML> Wed, 03 May 2017 07:41:05 GMT Anonymous 2017-05-03T07:41:05Z Compare quantity to find Date https://community.qlik.com/t5/QlikView/Compare-quantity-to-find-Date/m-p/1355157#M416000 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>The title is not very clearan example will be more at least I hope <span class="lia-unicode-emoji" title=":winking_face:">😉</span></P><P>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.</P><P>The Date used for the Forecast quantities (Planned Quantity) = Date_Plan.</P><P>The Date used for the actual quantities is Date.</P><P>Thank you in advance,</P><P><IMG alt="2017-04-28+11_45_45-QlikView+x64+-+[C__Users_epetrini_Desktop_Cust+Part+Price+Amort+TMA.qvw].png" class="jive-image image-1" src="/legacyfs/online/161984_2017-04-28+11_45_45-QlikView+x64+-+[C__Users_epetrini_Desktop_Cust+Part+Price+Amort+TMA.qvw].png" style="height: 221px; width: 620px;" /></P></BODY></HTML> Wed, 03 May 2017 07:41:05 GMT https://community.qlik.com/t5/QlikView/Compare-quantity-to-find-Date/m-p/1355157#M416000 Anonymous 2017-05-03T07:41:05Z