7 Replies Latest reply: Apr 20, 2015 9:49 AM by Nayan Lalla RSS

    Totals on Chart Straight Table not adding up

    Nayan Lalla

      Hi

       

      In our business, we sell a component as well as the final product in which the component goes to.  Below is a screen shot of of my chart straight table showing 6 months sales and Stock on Hand (SOH). The SOH is the Item SOH multiplied by the Component Quantity.

      We sell to our  branch and to customers (ie "Sell Out") .  In my table, I Ignore sales to Branch , hence the list box sales status , "Sell Out" is selected.

       

      I am struggling to get the correct total for the column Stock on Hand (SOH) below.  I want to show SOH, even if the item is not sold.  In my example, item JKL.  

       

      The correct total for ABC should be 23,273 & for JKL is 723,449. 

       

      Attached herewtih is the Qlikview Model as well as the Database in Excel Spreasheet.

       

      Please can you help

       

      kind regards

      Nayan

      Sales Status.JPG

      SOH.JPG