topic For Loop with two variables in QlikView

For Loop with two variables

BHoll — Thu, 25 Apr 2019 15:40:31 GMT

Hello Everyone,

i'm trying to figure out, how to code a for loop in Qlikview that is iterating throught two variables at the same time (no nested for Loop)

I imagine the code to work like this:

for each vNumber,vLetter in ((1,2,3,4),(A,B,C,D))

trace$(vNumber);

trace$(vLetter);

Next;

Desired Output would be:

best regards,

smbeholl

Re: For Loop with two variables

sunny_talwar — Thu, 25 Apr 2019 16:10:06 GMT

Will you always have the same number of items in vNumber and vLetter? and how are they two linked together? the order of their listing?

Re: For Loop with two variables

Vegar — Fri, 26 Apr 2019 04:33:18 GMT

You would need to create two loops to accomplish this. One per variable.

for each vNumber in 1,2,3,4
for each vLetter in 'A', 'B', 'C','D'
trace$(vNumber);
trace$(vLetter);
Next;
Next

Re: For Loop with two variables

BHoll — Fri, 26 Apr 2019 06:50:43 GMT

I'll always have the same number of items in vNumber and vLetter. Not sure if i'm getting the second part of you question right, but like in my opening post, both variables should take the first value of their list first, then the second and so on.

thanks for your help!

Re: For Loop with two variables

BHoll — Fri, 26 Apr 2019 06:57:45 GMT

@Vegar wrote:
You would need to create two loops to accomplish this. One per variable.

for each vNumber in 1,2,3,4
for each vLetter in 'A', 'B', 'C','D'
trace$(vNumber);
trace$(vLetter);
Next;
Next

This is a nested for loop and will give me the following output:

....

Re: For Loop with two variables

Vegar — Fri, 26 Apr 2019 07:03:35 GMT

Re: For Loop with two variables

BHoll — Fri, 26 Apr 2019 07:56:27 GMT

Thanks, this is definetly a good work around!