Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Creating subtotals within a pivot table

Hi all

For the Pivot table below I am looking to create sub totals for the Category field based on the selections in the red boxes (i.e. a sub total for Blend Milk Based, Goldstart, and SureStart. A further sub total for EasiStart/Milkiwean, MultiStart, and Vital etc).  I am new to Qlikview and do not have much developing experience and would really appreciate any help that you can provide.

Untitled.png

3 Replies

Re: Creating subtotals within a pivot table

James

On your Pivot Table's, Presentation tab for the corresponding expressions tick Show Partial Sums.

Not applicable

Re: Creating subtotals within a pivot table

Hi Bill

Ticking Show Partial Sums only shows me the sub total for each value within a field. I am looking to show a sub total for a grouping of values with a field. So looking at my pivot table I am looking to show sub totals within the Category field. The first sub total would be for the values Blend Milk Based, Goldstart, and SureStart.

Re: Creating subtotals within a pivot table

James

Did you tick it on Manufactured?

Best Regards,     Bill

Community Browser