for each ... next using field values

[#1]

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?

[hic · Accepted solution]

You need extra single quotes inside the list.

But a better way to do this is:

Test:

NoConcatenate

Load Distinct A From Data.qvd (qvd);

for vRow = 1 to NoOfRows('Test')

   Let MyVar = Peek('A',vRow-1,'Test');

   some command ...

   load

   ...

   Where A = '$(MyVar)';

   ...

Next

//HIC

[#3]

Thanks ... works fine