11 Replies Latest reply: Aug 2, 2011 10:15 PM by Teles 13 RSS

    Formula in getting the  exact quantity

      Hi all,

       

      Good Day

       

      Im new in qlikview please help me how to get the exact report.

       

      This is my qvw file.This is my concern.the DELIVERY QTY. has a exact qty.my problem is the QTY REDUCED are not tally.but the others are correct qty.

      To make my concern clear...When i select the puchasing doc 4600005585 the delivery qty and the qty reduced are all tally based on the report of SAP.but when i select the puchasing doc 4600003085 the delivery qty is correct qty but the qty reduced are not.

       

      i dont know how to get the exact qty in QUANTITY REDUCED.i already mix my script but i dont get what i need to see in my report.

       

      And also how to get the total qty in delivery qty , qty reduced and the picking qty.This is also my problem.

       

      Please help me.

       

      Thank you so much for your help.

       

      Teles