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