This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I created a sales report that contains data from our ERP
It shows customer, item purchased, price, qty, ...
My table looks like this:
DATE CUSTOMER INVOICE N° ITEM QTY UNIT PRICE TOTAL
1 A iA 5 1 5
2 B iA 2 1 2
3 A iB 4 10 40
4 B iA 10 1 10
I can select a specific customer, a specific date or a specific item and I get the sales for a specific date
I'd like to be able, when selecting a customer, to have the total qty bought for each item
So it would look like something like this:
CUSTOMER ITEM TOTAL QTY
A iA 5
A iB 4
B iA 12
Any help is appreciated.Let me know if my question don't make sense !
you don't need any thing here
Create straight table
Dim - CUSTOMER, ITEM
Measure - Sum(QTY)
View solution in original post
like this? if not what is the logic to derive Total Qty?