4 Replies Latest reply: Sep 8, 2016 6:30 AM by renjith pl RSS

    Selecting Multiple Values in field using a variable

    Sk Sakir Ali

      Hi,

       

      I have a problem where I need to select Field on the basis of some calculation. After calculation value is stored in a variable as comma separated values. I need to create a button that will select only those values that are present in that variable.

       

      For Example:

       

      t1:

      LOAD * INLINE [

          F1, F2

          a1, a

          b2, c

          c3, v

          e1,d

          f1,g

      ];

       

      After Calculation

      vVar contains a1,c3,f1

       

      Button:

       

      Select in Field:

       

      Field

      F1

       

      Search String:

      =ValueList($(vVar))

       

      It is not working as expected.

       

      Please share your experience and knowledge.

       

      Thanks in advance.

       

      Regards,

      Sakir