topic Re: sum function results are wrong in QlikView

sum function results are wrong

Tue, 14 Oct 2014 08:37:29 GMT

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.

Re: sum function results are wrong

Gysbert_Wassenaar — Tue, 14 Oct 2014 09:02:49 GMT

It's impossible to tell from your description what the cause is. Can you post a document that demonstrates the problem?

Re: sum function results are wrong

simondachstr — Tue, 14 Oct 2014 09:06:07 GMT

All row-sums do not tally or just the totals?

Re: sum function results are wrong

Tue, 14 Oct 2014 09:21:42 GMT

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	-

Re: sum function results are wrong

PrashantSangle — Tue, 14 Oct 2014 09:25:23 GMT

Hi,

You dont need to use Aggr()

just write lineCost in expression

Or you can try like

Aggr(sum(linecost),store,PO_num)

Regards

Re: sum function results are wrong

Tue, 14 Oct 2014 09:43:02 GMT

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

Re: sum function results are wrong

PrashantSangle — Tue, 14 Oct 2014 09:45:26 GMT

Hi,

Can you share your apps?

Regards,

Re: sum function results are wrong

simondachstr — Tue, 14 Oct 2014 10:34:29 GMT

This looks like a data model issue. Try putting sum(linecost) in a textbox and cross check with your Excel sheet.