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.

[Siva_Sankar]

Could you share your application? or share the screenshot?

-Siva

[pnn44794]

Hello Sivasankar:

I could, but it would take me a little bit of time to prepare it for sharing.  However, I believe I've solved the issue.  Please see my response to Peter Rieper.

[pnn44794]

Hello Tamil:

I could, but it would take me a little bit of time to prepare it for sharing.  However, I believe I've solved the issue.  Please see my response to @Peter Rieper@.

[pnn44794]

Hello Jonathan:

Thanks for the reply.  Suppress Null values is not checked.  I believe I've resolved the problem after reading Peter's last response to me.  Please see my response to Peter.

[pnn44794]

Hello Yusuf:

Thanks for the reply.  I did both with no luck.  However, I believe the problem is resolved.  Please see my response to @Peter Rieper.

[pnn44794]

Hello Peter:

I tried that but with no luck.  However, you're other reply which I'll respond to, made me look at my datamodel and what I was using in the calculation.

[pnn44794]

Hello Prashant:

thanks for the reply.  I have not tried this yet, though I believe I have a solution.  Please see my response to @Peter Rieper.

[pnn44794]

Hello Peter:

You've pointed me in the right direction!  I do have multiple tables that are being loaded and apparently the two tables in play with this are not a 100% match (join).  I was using Approval Complete Year from one table and PROD_KEY from another table.

Once I used just one of the tables and changed PROD_KEY to a different column from the same table that Approval Complete Year is in, I got the results I was expecting, 303.  I had to change the expression to a Count versus a Sum, but I get the right results.

Thank you very much!!!