4 Replies Latest reply: Jul 13, 2012 9:24 AM by Fien Verrue RSS

    How to create a dynamic fieldname in an expression

      Hi all,

       

      I want to use a dynamic fieldname in an expression, but I need some help.

       

      In my project I have several fieldnames like:

      Ind_AA_Time

      Ind_BB_Time

      Ind_CC_Time

      Ind_DD_Time

       

      The 'AA', 'BB', 'CC' en 'DD' are types of indicators and are stored in a table named 'Indication'.

       

      I want to build the fieldnames dynamicly so I can use them in an expression in a pivot table. So the value of the fieldname is depending on the type of indicator. The indicator is a dimension of the pivot table.

       

      My expression is now like this:

       

      ='Ind_'&Indication&'_Time'

       

      It shows the correct fieldname into the column, but not the value of that field.

       

      test.png

       

      How can I build this expression, that it will return the value of the fieldname into the column? I'm sure it will be something silly, but I can't see a solution at this moment.

       

      Thanks in advantage!