Discussion Board for collaboration on QlikView Layout & Visualizations.
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.
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)
=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