Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I did a pivot table in excel:
Store | PO_num | Sum of linecost |
---|---|---|
A | 1234 | 56456 |
B | 1234 | 34573 |
C | 1234 | 35747 |
Total | 126776 |
But when I did a straight table version of the excel pivot table in qlikview, the numbers do not tally.
I tried using the formulas 'sum(linecost)' and 'aggr(sum(linecost),PO_num,Store)' but it does not work.
Thanks.
It's impossible to tell from your description what the cause is. Can you post a document that demonstrates the problem?
All row-sums do not tally or just the totals?
When I just do a table box plainly displaying the Store,PO_num and the respective linecosts, the values are correct, but when I put the dimensions Store,PO_num and the expression 'aggr(sum(linecost),PO_num)' in a straight table, the sums are accumulated and displayed for only 1 Store (See below):
Store | PO_num | aggr(sum(linecost),PO_num) |
---|---|---|
A | 1234 | - |
B | 1234 | 126776 |
C | 1234 | - |
Hi,
You dont need to use Aggr()
just write lineCost in expression
Or you can try like
Aggr(sum(linecost),store,PO_num)
Regards
Hi, I've tried 'Aggr(sum(linecost),store,PO_num)' but the sums are wrong:
Store | PO_num | Sum of linecost |
---|---|---|
A | 1234 | 56456 |
B | 1234 | 34573 |
C | 1234 | 35747 |
Hi,
Can you share your apps?
Regards,
This looks like a data model issue. Try putting sum(linecost) in a textbox and cross check with your Excel sheet.