topic Re: How to sum only 1 amount per invoice in QlikView

How to sum only 1 amount per invoice

Mon, 07 Jan 2013 20:22:58 GMT

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.

thx in advance.

Mon, 07 Jan 2013 20:35:43 GMT

Try the following expression:

Sum(aggr(NoBoxes,InvoiceNo,NoBoxes))

Mon, 07 Jan 2013 20:47:25 GMT

Hi Rebecca,

Thanks for your answer almost at lightning speed, this works perfect.

Kind Regards

Ron