Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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
Highlighted
Not applicable

Re: How to sum only 1 amount per invoice

Try the following expression:

Sum(aggr(NoBoxes,InvoiceNo,NoBoxes))

2 Replies
Highlighted
Not applicable

Re: How to sum only 1 amount per invoice

Try the following expression:

Sum(aggr(NoBoxes,InvoiceNo,NoBoxes))

Not applicable

Re: How to sum only 1 amount per invoice

Hi Rebecca,

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

Kind Regards

Ron

Community Browser