Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try the following expression:
Sum(aggr(NoBoxes,InvoiceNo,NoBoxes))
Hi Rebecca,
Thanks for your answer almost at lightning speed, this works perfect.
Kind Regards
Ron