Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Subtotals on a pivot table

I'm having trouble adding subtotals to my pivot table. I've selected show partial sums against the dimensions that I need to show totals for but they do not appear. One of my dimensions I have changed to a number using the num() function but that doesn't seem to be the issue


4 Replies
awhitfield
Esteemed Contributor

Re: Subtotals on a pivot table

HI Andrew,

Can you upload a example qvw please?

Andy

buzzy996
Honored Contributor II

Re: Subtotals on a pivot table

from style tab--there is check box Indent mode,can u check tht one and see?

Not applicable

Re: Subtotals on a pivot table

Hi

I've attached my file below

Re: Subtotals on a pivot table

Hi,

Instead of writing just fieldname as expression write

Sum(FieldName)

like

Sum(Salesorderlocalsql )

regards

Regards,
Prashant Sangle
Community Browser