Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Announcement: We have made updates to resolve a Page Not Found error. If you still get this error, please let us know in the Community Corner.
Highlighted
yashcena
New Contributor II

'Total' on excel export is incorrect

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

Labels (3)
1 Reply
pradosh_thakur
Honored Contributor II

Re: 'Total' on excel export is incorrect

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.
Learning never stops.