Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.