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

    Dynamic Name of Total of a Dimension in Pivot Tables

    Bettina Schewe

      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