topic Re: Pivot Table Totaling in QlikView

Pivot Table Totaling

Wed, 27 Apr 2011 14:32:14 GMT

How do you show both Column and Row totals in a pivot table. In the presentation tab, "Show Partial Sum" seems to always be grayed out when there ismore than one dimension.

Any help?

Pivot Table Totaling

Wed, 27 Apr 2011 14:36:01 GMT

In my understanding partial sum is not working in expressions. If u want to use it then insert it into dimensions.

Pivot Table Totaling

Wed, 27 Apr 2011 14:38:51 GMT

Thanx for the reply.

Irrespective of the dimension or expression, how do you show both column and row totals?

AW:Re: Pivot Table Totaling

brenner_martina — Wed, 27 Apr 2011 14:44:14 GMT

Hi,

always the partial sum is only for dimensions. If you want to get sum for expressions, you have to enter a new expression and sum here all columns like:

Column(1)+Column(2) + ... +Column(N)

Sum(Sales) + Sum(Websales) +...

or using the expression labels

[Sum Sales] + [Sum Websales] + ...

Pivot Table Totaling

Wed, 27 Apr 2011 14:50:02 GMT

Im sorry im new in QV.

Maybe you're looking for this http://community.qlik.com/forums/t/44884.aspx

Pivot Table Totaling

erichshiino — Wed, 27 Apr 2011 14:51:52 GMT

Only works for dimensions you can enable the show partial sums for as many dimensions as you want. On the presentation tab select the dimension one by one to check the 'show partial sums'

If you have a dimension as columns you can have a horizontal total

If you have a dimension as row you can have a vertical total.

If you have more than one expression and want to sum them, you need to write an expression for this.

AW:Re: Pivot Table Totaling

Wed, 27 Apr 2011 14:53:14 GMT

Hmm...the issue Im having is in a pivot table, all of the information I need summed is in one field. In the pivot, the different identifiers from the given field are the column headers. I need to sum the values across so each of the column headers creates a new column called total.

If the rows are dates and the column headers are Products, how do I sum across so I get a total for a single date?

Pivot Table Totaling

Wed, 27 Apr 2011 14:55:50 GMT

Muncho.

That makes perfect sense, but the issue I am experiencing is that in the presentation tab, when I go to select show partial sum, it is not allowing me to select it. The box is grayed out and uncheckable

AW:Re: Pivot Table Totaling

brenner_martina — Wed, 27 Apr 2011 14:57:28 GMT

Do you have an example file?

AW:Re: Pivot Table Totaling

Wed, 27 Apr 2011 15:17:22 GMT

Here is the Pivot Table Example

AW:Re: AW:Re: Pivot Table Totaling

brenner_martina — Wed, 27 Apr 2011 15:33:39 GMT

Hi, fujimedical,

I entered a new pivot chart and now it works! I have no idea why it dosn't work in your chart?

Pardon, its not possible to upload a file here

AW:Re: AW:Re: Pivot Table Totaling

brenner_martina — Wed, 27 Apr 2011 15:51:45 GMT

File upload not possible, send me an email for attaching the file:

brenner@dreamteam-solutions.de

Pivot Table Totaling

Fri, 08 Jun 2012 11:24:13 GMT

Try disabling the 'Indent Mode' in the Style-tab, if that option is disabled then the 'Show Partial Sums' option on the Presentation-tab is not greyed out anymore. The 'Indent Mode' can be enabled later while your choice for the 'Show Partial Sums' option will be unchanged.

Re: Pivot Table Totaling

christian77 — Fri, 08 Jun 2012 11:54:22 GMT

Hi:

Open your pivot table properties dialog. Add a new expression: dimensionality() & ‘ – ‘ & secondarydimensionality() and see the result.

Totals have dimensionality()=0 and partial totals one dimensionality() less than the normal cells. Expand and collapse your table to see how it acts.

Secondarydimensionality() works when you have a pivoted dimension or more.

To totalize, for example, say:

If (dimensionality()=0, [your total expression], [your normal expression])

I hope it helps.

Re: Pivot Table Totaling

tiagopost — Tue, 07 Jul 2015 03:40:50 GMT

Perfect