Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. 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?

View solution in original post

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

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.

Highlighted

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?

View solution in original post