Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Partner
Partner

Sum Mismatch Between Qlikview and Excel

Hello:

I have a dataset (full data sample attached) 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.

The calculation used in the Straight table is:

=Sum({<[Approval Complete Year]= {'2018'},PROD_KEY = {'VSI Power Unknown VM', 'VSI Standard Non-Prod VM', 'VSI Standard Prod VM', 'VSI x86 Dedicated VM', 'VSI x86 Dev VM', 'VSI x86 Prod VM', 'VSI x86 ST VM', 'VSI x86 UAT VM', 'VSI x86 Standard VM'}>} NET_ASSETS)

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

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?