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.
Solved! Go to Solution.
It could also be that you have checked "Suppress Nulls" on a dimension.
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.
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.