topic Re: Pivot table sums should include values for surpressed dimensions in QlikView

Pivot table sums should include values for surpressed dimensions

janbouwmans — Fri, 09 Sep 2016 08:09:59 GMT

I am struggling with the following:

I need to sum the values in a Pivot table, including the cases where the Dimension = empty, even when these are surpressed.

For example:

In the above example the Empty values in dimensions are not surpressed. The totals include values for these empty

When the empty value dimensions are hidden it looks like this:

How can I show the totals including values from Surpressed dimensions ( So avoid that the totals change when I surpress empty values in dimension)

sunny_talwar — Fri, 09 Sep 2016 21:17:03 GMT

This?

Dimension

Business

Country

Expression

=If(Dimensionality() = 1 and SecondaryDimensionality() = 0, Sum(Aggr(Sum(Value), Business)),

If(Dimensionality() = 0 and SecondaryDimensionality() = 1, Sum(Aggr(Sum(Value), Country)),

If(Dimensionality() = 0 and SecondaryDimensionality() = 0, $(vTotal), Sum(Value))))

Here $(vTotal) is a variable with the following definition

=Sum(Value)