Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

sum function results are wrong

Hi, I did a pivot table in excel:

StorePO_numSum of linecost
A123456456
B123434573
C123435747
Total126776

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.

7 Replies

Re: sum function results are wrong

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


talk is cheap, supply exceeds demand
Luminary
Luminary

Re: sum function results are wrong

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

Not applicable

Re: sum function results are wrong

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):

StorePO_numaggr(sum(linecost),PO_num)
A1234-
B1234126776
C1234-

Re: sum function results are wrong

Hi,

You dont need to use Aggr()

just write lineCost in expression

Or you can try like

Aggr(sum(linecost),store,PO_num)

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Not applicable

Re: sum function results are wrong

Hi, I've tried 'Aggr(sum(linecost),store,PO_num)' but the sums are wrong:

StorePO_numSum of linecost
A123456456
B123434573
C123435747

Re: sum function results are wrong

Hi,

Can you share your apps?

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Luminary
Luminary

Re: sum function results are wrong

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

Community Browser