Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Pivot Table row totals

I have a pivot table and would like to show totals at the end of each row.

When I add 'show partial sum' this add it to the columns and not rows!

Can this be changed anywhere?

I've looked in all the properties and can't find anything that jumps out as row totals.

Andy

1 Solution

Accepted Solutions
MVP
MVP

Re: Pivot Table row totals

Hi

If you have pivoted any dimensions to column headings, you can total the rows using partial sums. If you have no dimensions in the column headings (ie only expressions), then the partial sum does not work. Instead, you can total the rows by creating a total expression that adds the columns:

     =Column(1) + Column(2) + Column(3) .....

Hope that helps

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
2 Replies
MVP
MVP

Re: Pivot Table row totals

Hi

If you have pivoted any dimensions to column headings, you can total the rows using partial sums. If you have no dimensions in the column headings (ie only expressions), then the partial sum does not work. Instead, you can total the rows by creating a total expression that adds the columns:

     =Column(1) + Column(2) + Column(3) .....

Hope that helps

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable

Re: Pivot Table row totals

Thanks Jonathan

Much appreciated.

Andy

Community Browser