This content has been marked as final. Show 2 replies
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.