topic Re: Pivot Table partial Sums for conditional dimensions in QlikView

Pivot Table partial Sums for conditional dimensions

Tue, 01 Nov 2016 16:46:16 GMT

We have a pivot table with Conditional dimensions. We want to enable partial sums for only 4 dimensions. But since all dimensions are conditional and partial sums are based on the next columns its causing issues. If we hide the column with partial sum enabled, the previous column doesn't show partial sum. Any idea on How to make the partial sum constant on the 4 dimensions irrespective of which other dimensions are selected?

Re: Pivot Table partial Sums for conditional dimensions

sunny_talwar — Tue, 01 Nov 2016 17:56:35 GMT

Would you be able to share a sample to show your issue? May be also provide the expected output?

Re: Pivot Table partial Sums for conditional dimensions

Tue, 01 Nov 2016 21:36:03 GMT

Hi,

We have a pivot table as shown below where we have many dimensions. All the dimensions are conditionally enabled.

The below 4 should always have Subtotals as shown below. They can also be hidden. We can add more dimensions which don't have subtotals enabled. When they are added in between any of the below columns, the Subtotals for these columns will not show as they will not have subtotals enabled.

Is there a way to always show subtotals only for the below 4 columns irrespective of new dimensions added?

Dim 1	Dim 2	Dim 3	Dim 4	Expr1
-	-	-	-	18674469.869098
		-	Total	18674469.869098
		Total		18674469.869098
	Total			18674469.869098
Total				18674469.869098

Re: Pivot Table partial Sums for conditional dimensions

sunny_talwar — Wed, 02 Nov 2016 01:30:12 GMT

I am still not sure what you might be looking to get. Would you be able to share a qvw where you are trying this?