2 Replies Latest reply: Mar 22, 2012 3:53 PM by jonahall RSS

    How to use a string as a function/expression? = indirect (excel) and eval (matlab)

      I want to set a variable (FC) either to be a factor ("*1.3") or a summand ("+0.3"). This variable shall then be used as a function on the field "price":

       

      eval('price'&FC)

       

      In Matlab this would work. or in excel it would be:

       

      indirect('price'&FC)

       

      But how can I do this in QlikView?

       

      Best,

      Joans