topic Re: Values in Straight Table don't add up correctly in QlikView

Values in Straight Table don't add up correctly

Mon, 30 Jun 2014 17:52:46 GMT

I can't figure out why I'm getting values that don't add up in my straight table. Some high level examples...$1,311,441,221 near the bottom left actually should total $1,311,437,447. All of the totals at the bottom are off when I add up the sub-totals, which in turn is making my %'s on the right side of the table off. I tried changing it to a pivot table - because the sub-totals are in the dimension limits I'm unable to even get the sub-totals in there. The totals by term are each correct - i.e., the value in $s at 12 months does total corerctly at $4,080,975. Any ideas?

Re: Values in Straight Table don't add up correctly

vgutkovsky — Mon, 30 Jun 2014 19:33:45 GMT

Barbara, I just manually added your Costs (adding the Total by Term subtotal amounts) and it comes to 1,311,443,221...

Vlad

Re: Values in Straight Table don't add up correctly

Mon, 30 Jun 2014 19:46:30 GMT

By default Qlikview will use expression for total as method for calculating totals which means that your expressions are evaluated on the next level which may end up giving you an different value that the expected sum of values in all rows.

Have you tried changing the Total mode of your expression from Expression Total to Sum of Rows?

Re: Values in Straight Table don't add up correctly

Mon, 30 Jun 2014 19:57:15 GMT

Aha! That fixed it. Thank you so much!