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 ...




      Where A = '$(MyVar)';





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

      What am I doing wrong?