2 Replies Latest reply: Feb 25, 2011 10:23 AM by emaC RSS

    How do I calculate Margin in Qlikview

      Hi,

       

      I have just started using Qlikview v9.0 and i'm trying to calculate Margin in a straight chart but can't get it to work, can someone help tell me what I'm doing wrong?

      The Calculation is: Sum ((Amount)-Sum(Credit Amount)-sum(%_Qty*ItemsCost))/Sum(Amount)

      Thanks