3 Replies Latest reply: Jul 16, 2015 1:16 AM by Settu Periyasamy RSS

    Dynamic expression generated by string concatenation based on user input

      Is is possible to form an expression dynamically in script? For example, I would like to have a sum function, where columns to sum are based on user input.

       

      In the script, I defined a variable to form the full expression:

      Set vSumFieldSelections = 'Sum([' & GetFieldSelections([fieldName],']+[') & '])';

       

      Then my expression in one of the QlikView text object:

      =$(vSumFieldSelections)

       

      Thanks