topic creating totals in a pivot table in QlikView

creating totals in a pivot table

Tue, 05 Nov 2013 09:31:18 GMT

Hi guys,

I have a questions regarding the totals in a pivot table. I've noticed that if I create total by selecting Show partial Sums, it will display the sums of the measures. What if I don't want to display the sums?

In the attachment you'll find a pivot table which shows up the Actual Prices, MP Prices, PY Prices Mth and PY Prices Avg for each Group Material, split for month.

Now I want to show up these indicators at total level, not including the detail for Group Material.

How can I do?

Please, see my attchament.

Re: creating totals in a pivot table

jvitantonio — Tue, 05 Nov 2013 09:43:45 GMT

Hi Cristina,

If you don't want this level of granularity, then remove Group Material and leave only the Month that you are using as columns.

Then, replace your formulas with an aggregation by group material:

sum(aggr([Act/Fact], [GroupMateria], Month))

I hope this helps.

BI Experience | A place to share our Business Intelligence experiences

Re: creating totals in a pivot table

Gysbert_Wassenaar — Tue, 05 Nov 2013 11:27:53 GMT

Try creating a new field and use that in the pivot table

TableForExtraField:

LOAD * inline [

GROUP_FOR_PIVOT, GROUP MATERIAL

Natural Rubber, Natural Rubber

Synthetic Rubber, Synthetic Rubber

Carbon Black, Carbon Black

Chemicals, Chemicals

Textile reinforc., Textile reinforc.

Metallic reinforc., Metallic reinforc.

Total, Natural Rubber

Total, Synthetic Rubber

Total, Carbon Black

Total, Chemicals

Total, Textile reinforc.

Total, Metallic reinforc.

];

If you then use GROUP_FOR_PIVOT instead of GROUP MATERIAL you'll get the Totals at the end like you want.