Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

janbouwmans
New Contributor II

Pivot table sums should include values for surpressed dimensions

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:

Test QV Not surpressed.png

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:

Test QV surpressed.png

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

1 Reply

Re: Pivot table sums should include values for surpressed dimensions

This?

Capture.PNG

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)

Community Browser