Wrong Total in Qlikview Table

[Anonymous]

Hi all,

I have faced this issue a several times.

Whenever I export data from a Qlikview chart to Excel sheet. The total tab in Qlikview shows Different numbers from the one that we get by actually Calculating the total.

Below is the screenshot.

Is this a bug?

[suryaa30]

Could be due to Rounding of numbers.

[sunny_talwar]

Try to total using Sum(Aggr(Expression, Dimensions))

[rwunderlich]

I'm guessing that for the Excel total, you are summing rows.  QlikView does not sum rows by default, rather it recomputes the total by running the expression over all data.  In that way it does not double count a measure that exists in more than one dimension value (rows) on the chart.  This is generally considered to be correct.

In a straight table, you cna swtich to "Sum of Rows" if you want on the Expression tab in the "Total Mode" section.  In a Pivot table (or any table) you can use the Aggr() that SUmmy suggested to achieve Sum of Rows.

-Rob