'Total' on excel export is incorrect

yashcena — Sat, 16 Nov 2024 04:34:54 GMT

Hi,

I have a chart in which I'm showing Application Name and Total Hours. When I enable the partial sum, I get the sum of total hours.

But when I disable the partial sum, export it and take the sum of 'Total Hours', that figure is totally different.

I think whatever properties/options are applied on the chart, those would still be applicable on the exported dataset (like supress when value is null etc.)

I mean if the nulls are supressed in the chart, then the exported dataset would also have nulls supressed.

Has anyone come across this issue.

Any help would be appreciated!

Thanks,

YASH

Re: 'Total' on excel export is incorrect

pradosh_thakur — Fri, 01 Feb 2019 13:17:09 GMT

As you said you are enabling partial sum you must be using Pivot table. To get the totals you might need to use an aggr() function.

topic 'Total' on excel export is incorrect in QlikView

'Total' on excel export is incorrect

Re: 'Total' on excel export is incorrect