Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Partner
Partner

Sum Mismatch Between Qlikview and Excel

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.

 

1 Solution

Accepted Solutions
prieper
Honored Contributor II

Re: Sum Mismatch Between Qlikview and Excel

What does your datamodel look like?

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

17 Replies

Re: Sum Mismatch Between Qlikview and Excel

Hi Perry,

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

Siva_Sankar
Honored Contributor

Re: Sum Mismatch Between Qlikview and Excel

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?

color.JPG

MVP
MVP

Re: Sum Mismatch Between Qlikview and Excel

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
prieper
Honored Contributor II

Re: Sum Mismatch Between Qlikview and Excel

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
Contributor III

Re: Sum Mismatch Between Qlikview and Excel

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

Highlighted
prieper
Honored Contributor II

Re: Sum Mismatch Between Qlikview and Excel

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.

Re: Sum Mismatch Between Qlikview and Excel

Try below,

sum(Aggr(YourCurrentExpression,all_dimension_present_in_your_current_chart))

Regards

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

Re: Sum Mismatch Between Qlikview and Excel

Hello Sivasankar:

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

prieper
Honored Contributor II

Re: Sum Mismatch Between Qlikview and Excel

What does your datamodel look like?

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