Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

'Total' on excel export is incorrect


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!




Labels (3)
1 Reply
Master II
Master II

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.