topic Re: for each ... next using field values in QlikView

for each ... next using field values

Tue, 13 Nov 2012 07:31:55 GMT

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?

Re: for each ... next using field values

hic — Tue, 13 Nov 2012 08:24:37 GMT

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)';

...

//HIC

Re: for each ... next using field values

Tue, 13 Nov 2012 15:58:50 GMT

Thanks ... works fine