topic Re: for each loop on a field in QlikView

for each loop on a field

Anonymous — Mon, 21 Mar 2016 23:12:20 GMT

Hello,

Would it be possible to use "for each" loop on a field of a table?

Like:

Let vfileList = Some_Kind_of_Function('fieldName'); //fieldName is a field of a table

for each vfile in $vfileList

Do something....

Thanks,

Josh

Re: for each loop on a field

jonathandienst — Tue, 22 Mar 2016 05:06:25 GMT

Use this code pattern:

For i = 0 To NoOfRows('tableName') - 1

Let vVal = Peek('fieldName', i, 'tableName');

// do something ....

Edit - added the '-1'

Re: for each loop on a field

Kushal_Chawda — Tue, 22 Mar 2016 05:42:44 GMT

Can you please explain the scenario?

Data:

Load Field1,

Field 2

From Table

let vFieldValueCount = FieldValueCount ('Field1');

For i=1 to $(vFieldValueCount)

let vFieldValue = FieldValue('Field1',$(i));

...

Next i

Re: for each loop on a field

Anonymous — Tue, 22 Mar 2016 17:04:10 GMT

Hello,

Thanks for answer.

Sorry I forgot the mention he point.

I want to drop the table as soon as the field is set to a list variable.

Thanks,

Josh

Re: for each loop on a field

jonathandienst — Wed, 23 Mar 2016 10:44:00 GMT

OK, so add the line

Drop Table tablename;

What precisely do you mean by "list variable"?

Re: for each loop on a field

Kushal_Chawda — Wed, 23 Mar 2016 10:47:25 GMT

Data:

Load Field1,

Field 2

From Table

let vFieldValueCount = FieldValueCount ('Field1');

For i=1 to $(vFieldValueCount)

let vFieldValue = FieldValue('Field1',$(i));

...

Next i

drop table Data;