Sum Mismatch Between Qlikview and Excel

[pnn44794]

Hello:

I have a dataset where within a Qlikview straight table, I get a Sum of 295.  When I export the data to Excel, I have a Sum of 303.  When I manually check the export, I also come up with 303 for a total.  I would appreciate any help in resolving the discrepancy.

As always, any and all help is appreciated.

[tamilarasu]

Hi Perry,

For me it's showing 303 in the straight table. Could you please attach sample qvw file.

[Siva_Sankar]

Hi Perry,

I too getting 303 for Product as dimension. Can you check whether you checked Sum of Rows instead of Expression Total or not?

[jonathandienst]

It could also be that you have checked "Suppress Nulls" on a dimension.

[prieper]

Following Jonathan's idea, it makes sense to create a straight table with just this expression - no dimensions.

Then the result should be as expected. Adding dimensions then should not change the result.

[vvvvvvizard]

in the expression tab , change from expression total to sum of rows or vice versa

[prieper]

With this formula and the underlying data, result should be the same, when choosing sum of rows, or expression total as there is just a simple filtercondition applied.

[PrashantSangle]

Try below,

sum(Aggr(YourCurrentExpression,all_dimension_present_in_your_current_chart))

Regards

[pnn44794]

Hello Sivasankar:

Thank you for your reply.  I do have Sum of Rows checked.

[prieper · Accepted solution]

What does your datamodel look like?

Do you have a duplication of data caused by duplicated entries in another table?