topic Pivot Table not showing Totals in QlikView

Pivot Table not showing Totals

sjhussain — Fri, 27 Nov 2015 15:06:47 GMT

Hello,

I am having problems with showing totals in Pivot Table.

I have two dimensions:

Sector

SubSector

The problem is with Sector Overhead Cost. I am using an aggregate function to just show the totals for each sector but not getting the Totals in the Sector Overhead Cost.

Expression:

=if(Dimensionality()=1,sum(aggr((sum({<COA_MAPTYPE={'Expense'}, CostType={'Sector Admin Cost'}>}EXPENSE)

- sum({<COA_MAPTYPE={'Expense'}, CostType={'Sector Admin Cost'}>}REVENUE)),COSTCENTRE_SECTOR)))

Will appreciate if someone can assist.

Thanks.

Re: Pivot Table not showing Totals

Clever_Anjos — Fri, 27 Nov 2015 15:09:38 GMT

You have a conditional to calculate only when Dimensionality()=1, right?

=if(Dimensionality()=1,sum(aggr((sum({<COA_MAPTYPE={'Expense'}, CostType={'Sector Admin Cost'}>}EXPENSE)

- sum({<COA_MAPTYPE={'Expense'}, CostType={'Sector Admin Cost'}>}REVENUE)),COSTCENTRE_SECTOR)))

Re: Pivot Table not showing Totals

sjhussain — Fri, 27 Nov 2015 15:11:39 GMT

The reason I have dimensionality() = 1 is to show only totals for each of the Sector. As the requirement is not to show values for the sub sectors . Show only Sector Totals.

Thanks.