2 Replies Latest reply: Aug 22, 2013 9:16 AM by Bettina Schewe

# Dynamic Name of Total of a Dimension in Pivot Tables

Hello,

i have tried to enter a formula in the field for the name for Totals of a Dimension ("Bezeichnung für Gesamtwerte").

The formula is stored in a variable and is this:

If (Dimensionality () = 0, 'Summe ' & GetObjectField (0),
If (Dimensionality () = 1, 'Summe ' & GetObjectField (1),

if (Dimensionality () = 2, 'Summe ' & GetObjectField  (2),

if (Dimensionality () = 3, 'Summe ' & GetObjectField (3),

if (Dimensionality () = 4, 'Summe ' & GetObjectField (4),

if (Dimensionality () = 5, 'Summe ' & GetObjectField (5),

if (Dimensionality () = 6, 'Summe ' & GetObjectField (6),

if (Dimensionality () = 7, 'Summe ' & GetObjectField (7),

if (Dimensionality () = 8, 'Summe ' & GetObjectField (8), 'Gesamt')))))))))

QlikView uses always the name of the first Dimension.

If I do not use a formula but a constant, it works.

Has anybody an idea about my mistake?

Bettina

• ###### Re: Dynamic Name of Total of a Dimension in Pivot Tables

You can't use dimension values in the total labels. Every label will use the same value as you noticed. You could instead try the approach described in this discussion. You'll have to decide if that's a workable option for you.

• ###### Re: Dynamic Name of Total of a Dimension in Pivot Tables

Thanks for your answer, but I fear, this is not what I need.

I want a dynamic name of the Total-Lines for each dimension.

For example, my first dimension is "company".

The total of each Company shoud have the name "Total < Company Name >".

As I have 6 Companies and about fourty entries in the 2nd dimension and so on I can't use an Inline Table.