2 Replies Latest reply: Nov 13, 2012 10:58 AM by mathiass. RSS

    for each ... next using field values

      Hi guys ... I need some help for the following problem.

       

      I want to  use a for each ... next loop with values of a field. Inside the loop I am using the loop variable to control a where clause.

      My code is looking like this:

       

      NoConcatenate Test:

      Load Distinct

      Concat(DISTINCT A, ', ') as MyList

      From Data.qvd (qvd);

       

       

      for each MyVar in MyList

       

      some command ...

       

      load

      ...

      Where A = '$(MyVar)';

       

      ...

       

      Next

      Now Qlikview ignores my comma segmented list (MyList) and take MyList as one value.

      What am I doing wrong?