Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

infosense_devel
Contributor II

Pivot table displays twise "Total" for partial sum label

Hello,

I have prepared one pivot table which contains Four dimensions, and MTD and PYTD expressions and I have do pivoting with one dimension called "Month".

In Presentation tab I have marked "Show Partial Sums" for all dimensions,

After than when I look into Pivot Table, it displays Two times Total in Partial sum of Month as like as below.

Need only One time Total as per below.

Thanks,

In Advance.

4 Replies
Partner
Partner

Re: Pivot table displays twise "Total" for partial sum label

Hi,

You should only have partial sums where it's relevant, otherwise you will get one Total for each dimension (resulting in more and more Totals the more complex your pivot is)

vishsaggi
Esteemed Contributor III

Re: Pivot table displays twise "Total" for partial sum label

Can you share this sample file to look into. Strange it should not display totals like that unless there is something happening in your dimensions.

infosense_devel
Contributor II

Re: Pivot table displays twise "Total" for partial sum label

Hello

Vishwarath Nagaraju,

Thanks for reply.

Please find attachment, which has scenario of twice "Total".

vishsaggi
Esteemed Contributor III

Re: Pivot table displays twise "Total" for partial sum label

You have a dimension named NAME which you are using in an expression. Expression usually should have some kind of calculation, not necessarily, but in your case your NAME field is a string field, so for a user you are displaying Names by month which does not make any analysis out of it. May be you want to show this way? Please find attached. So those double TOTALS were coming from your top list TEST and NAME which you are using in your expressions.