Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bettina13
Contributor III
Contributor III

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

2 Replies
Gysbert_Wassenaar

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.


talk is cheap, supply exceeds demand
bettina13
Contributor III
Contributor III
Author

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.