Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Could you share your application? or share the screenshot?
-Siva
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.
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@.
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.
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.
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.
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.
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!!!