Skip to main content
Announcements
Do More with Qlik - Qlik Cloud Analytics Recap and Getting Started, June 19: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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?

1 Solution

Accepted Solutions
hic
Former Employee
Former Employee

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

View solution in original post

2 Replies
hic
Former Employee
Former Employee

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

Not applicable
Author

Thanks ... works fine