Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
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
qlikviewnovice
Specialist II
Specialist II

Hi Khim,


Properties ;> Presentation 😆 Subtotals 😆 Subtotals on Top

Hope it helps!!

ecolomer
Master II
Master II

Is  this?

p46.png

Not applicable
Author

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.

Not applicable
Author

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

petter
Partner
Partner

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.

qlikviewnovice
Specialist II
Specialist II

Follow the Petter advice you will get expected output

PrashantSangle

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.
Not applicable
Author

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.

Not applicable
Author

Hi,

Unfortunately, the region is dynamic and cannot be hardcoded.