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
Siva_Sankar
Honored Contributor

Re: Sum Mismatch Between Qlikview and Excel

Could you share your application? or share the screenshot?

-Siva

Partner
Partner

Re: Sum Mismatch Between Qlikview and Excel

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.

Partner
Partner

Re: Sum Mismatch Between Qlikview and Excel

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@.

Partner
Partner

Re: Sum Mismatch Between Qlikview and Excel

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.

Partner
Partner

Re: Sum Mismatch Between Qlikview and Excel

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.

Partner
Partner

Re: Sum Mismatch Between Qlikview and Excel

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.

Partner
Partner

Re: Sum Mismatch Between Qlikview and Excel

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.

Partner
Partner

Re: Sum Mismatch Between Qlikview and Excel

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!!!