Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Pivot Table - Subtotal on the Top AND on the Right

I need in my pivot table to have subtotals on the top and on the right (instead of on the left).

Does any one know of a way to do this?

1 Solution

Accepted Solutions
fred_s
Contributor III

Re: Pivot Table - Subtotal on the Top AND on the Right

Hi Christina and Jaymerry,

Maybe it's better to get an answer you don't like than no answer at all.

Looks like there are just two options: top+left and bottom+right.
I guess for the Qlikview developers something like calculate SubTotals before or after the details.
Top and right would be the best solution, so this makes (at least) three of us.
Maybe they could calculate before and still show parts after the details.
I'll put it in the ideas part.

For Christinas Table Bottom+right should work, cause there probably never will be more months than twelve :-) and all of it will be visible all the time. To me Bottom+Right is a problem with bigger tables where People have to scroll down.

5 Replies
Not applicable

Re: Pivot Table - Subtotal on the Top AND on the Right

Hello,

A simple solution would it be ....mmm changing the order of the columns whereas the column that has the total just move it to the right.

cheers

pivottable.png

Not applicable

Re: Pivot Table - Subtotal on the Top AND on the Right

Did you try on presentation Tab Checking the Show Partial Sums box for any dimension and expression? That should work for you.

Regards,

Santiago.

Not applicable

Re: Pivot Table - Subtotal on the Top AND on the Right

I know where the show partial sums check box is. The issue is that my subtotals options are "Subtotals on Top" or "Subtotals on the Bottom". Is there a way to have my subtotals in the following image set up so that my subtotals for years is still at the top and have my subtotals for months along the right?

Capture.PNG

jaymerry
Contributor

Re: Pivot Table - Subtotal on the Top AND on the Right

Hello,

I have the same need.

Like in Christina's example, I'm trying to display in a pivot table the "SubTotal on Top" and to keep the subtotal column on the right.

Have you ever solved this kind of problem ?

Thank you for your help,

Best Regards,

Jaymerry

fred_s
Contributor III

Re: Pivot Table - Subtotal on the Top AND on the Right

Hi Christina and Jaymerry,

Maybe it's better to get an answer you don't like than no answer at all.

Looks like there are just two options: top+left and bottom+right.
I guess for the Qlikview developers something like calculate SubTotals before or after the details.
Top and right would be the best solution, so this makes (at least) three of us.
Maybe they could calculate before and still show parts after the details.
I'll put it in the ideas part.

For Christinas Table Bottom+right should work, cause there probably never will be more months than twelve :-) and all of it will be visible all the time. To me Bottom+Right is a problem with bigger tables where People have to scroll down.

Community Browser