Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Pivot Table Subtotal

Hi all,

How can I get the total for each dimension value in the pivot table? Currently when I enable the partial sum, I can only get the total value but not the total by each dimension value. (Please see the example below)

Capture.png

9 Replies
Highlighted
Specialist II
Specialist II

Re: Pivot Table Subtotal

Hi Khim,


Properties ;> Presentation 😆 Subtotals 😆 Subtotals on Top

Hope it helps!!

Highlighted
Master II
Master II

Re: Pivot Table Subtotal

Is  this?

p46.png

Highlighted
Not applicable

Re: Pivot Table Subtotal

Hi Enrique,

If you look at the last total column, it only shows 1 total.  But I want to break it into total for France, total for Germany and total for Spain.

Highlighted
Not applicable

Re: Pivot Table Subtotal

Thank you for the reply... please see my reply to Enrique below for more detail of the question.

Highlighted
MVP
MVP

Re: Pivot Table Subtotal

Then you can just drag the Region-label with your mouse to a position above the Type-label. This way you rearrange the Pivot Table to give you exactly what you ask for: One total for each Country and a Grand Total for everything.

Enrique's solution should work perfectly well for what you ask for - just do the little mouse adjustment.

Highlighted
Specialist II
Specialist II

Re: Pivot Table Subtotal

Follow the Petter advice you will get expected output

Highlighted

Re: Pivot Table Subtotal

Hi,

If you have Limited Region then you have remove Region Field from dimension tab

and add different expression for each Region  then only you will get desired result.

From Test File provide by Enrique

Just Remove Region Field from Dimension tab

and Add Below three expression in Expression Tab

1: Sum({<Region={"France"}>}Sales)

2: Sum({<Region={"Germany"}>}Sales)

3: Sum({<Region={"Spain"}>}Sales)

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Highlighted
Not applicable

Re: Pivot Table Subtotal

Hi Petter,

Maybe my question is not clear, but I need the total by type and also the total by country. Moving the country will remove the total by type.

Highlighted
Not applicable

Re: Pivot Table Subtotal

Hi,

Unfortunately, the region is dynamic and cannot be hardcoded.