topic Re: Sub totals simple table and pivot table in QlikView

Sub totals simple table and pivot table

Sat, 15 Aug 2015 22:57:42 GMT

Hi,

How can I put Sub Totals after Each Month (column) and each Year (column) in simple table and Pivot table :

Thx in advance

Re: Sub totals simple table and pivot table

marcus_sommer — Sun, 16 Aug 2015 08:44:58 GMT

Within a pivot-table you could simply enable sub-totals for each dimensions which you want within the object properties in tab presentation (top left). By a straight-table or a tablebox you need to create these additionally total-rows within the script and calculate the totals within the script (necessary by the tablebox) or within the gui with additionally conditions in the expressions. I suggest you choosed the pivot-table than the other objects haven't any real added value for the efforts they need for this.

- Marcus

Re: Sub totals simple table and pivot table

alibd225 — Sun, 16 Aug 2015 09:38:21 GMT

Dear Louis,

just check mark in show partial sums.

Re: Sub totals simple table and pivot table

svenkita — Sun, 16 Aug 2015 09:53:47 GMT

Attaching a sample for doing totals in a pivot table

if you right click on the pivot table and select properties

Presentation Tab

Select the dimension of year and month in the "Dimension and expressions"

and select show partial sum

hope this helps