Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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.


1 Solution

Accepted Solutions
Not applicable
Author

Try the following expression:

Sum(aggr(NoBoxes,InvoiceNo,NoBoxes))

View solution in original post

2 Replies
Not applicable
Author

Try the following expression:

Sum(aggr(NoBoxes,InvoiceNo,NoBoxes))

Not applicable
Author

Hi Rebecca,

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

Kind Regards

Ron