2 Replies Latest reply: Jan 7, 2013 3:47 PM by Ron Dreijer RSS

    How to sum only 1 amount per invoice

      Hi there,

       

      I'm quite new to qlikview and I have a small problem.

      In our database we have order lines with total invoice info.

      E.g. every order line has the invoice number of the invoice it belongs to.

      It also contains the total number of boxes for the whole invoice.

      How can I easily sum the number of boxes over a certain period?

      Suppose I want the sum of NoBoxes for the given data, I expect to get 11 as the result.

      Sum(NoBoxes) will return 23 which is wrong.

       

      Data.jpg


      thx in advance.