Grand Total of Complet report is diffrent than sum... - Qlik Community

Report Inappropriate Content · ‎2014-12-12

Hi
I have created report with huge data,when I export complet report in excel,the Grand total is not match with sum of all row.

what could be reason

Table is Starigh Table.

kushalthakral · ‎2014-12-12

Dear Ganesh

When you use straight table it removes duplicate values and that might be the reason in the calculation.

If possible please share ur sample file.

Regards

Kushal T

prieper · ‎2014-12-12

Are you sure to have exported all rows?

Especially earlier versions of Excel are limited to some 64000 rows (QV then continues on the next sheet)

HTH Peter

dickelsa · ‎2014-12-12

in addition to the answers above:

It could be possible that you have duplicate data, we cannot tell for sure though.

please attach sample data for better understanding.

Regards

Dick

Grand Total of Complet report is diffrent than sum of all row.