6 Replies Latest reply: Feb 2, 2017 7:14 PM by Marco Wedel RSS

    Using field content as variable name

    Herbert van Hoogdalem

      Hi,

       

      I have a problem with using the content of a field as a variable name that needs to be expanded.

      Consider this situation:

       

      In the script i set these (i want the users to be able to play with these values)

      LET vNiveau1Factor = 10;

      LET vNiveau2Factor = 20;

      LET vNiveau3Factor = 30;

      LET vNiveau4Factor = 40;

       

      INLINE table:

      NiveauFactor
      Niveau 1vNiveau1Factor
      Niveau 2vNiveau2Factor
      Niveau 3vNiveau3Factor
      Niveau 4vNiveau4Factor

       

      CHART

      Dimension (Niveau)Expression 1: =FactorExpression2: ?????
      Niveau 1vNiveau1FactorI would like to have an expression here that shows 10 (or current value)
      Niveau 2vNiveau2FactorI would like to have an expression here that shows 20 (or current value)
      Niveau 3vNiveau3FactorI would like to have an expression here that shows 30 (or current value)
      Niveau 4vNiveau4FactorI would like to have an expression here that shows 40 (or current value)

       

       

      I would like Expression2 to show the actual value of the variables.

      I can't seem to find the correct $-expansion for this case.

      =$('=Factor') doesn't work....

       

      Could any1 shine a light on this?

       

      Thanks

       

      Herbert