topic Re: Simple For...Next Not Working in QlikView

Simple For...Next Not Working

Qvmaster2019 — Wed, 25 Jul 2012 11:09:34 GMT

This one is only getting the first record (aalfonso):

tblusers:

LOAD * INLINE [

Users

aalfonso

aantolini

];

FOR i = 0 to 1

LET arg = peek('Users',$(i));

TEST:

LOAD * INLINE

[

Test

$(arg)

];

Re: Simple For...Next Not Working

Qvmaster2019 — Wed, 25 Jul 2012 11:14:57 GMT

But this one works:

tblusers:

LOAD * INLINE [

Users

aalfonso

aantolini

];

FOR i = 1 to 2

LET arg = fieldvalue('Users',$(i));

TEST:

LOAD * INLINE

[

Test

$(arg)

];

Any idea?

Re: Simple For...Next Not Working

Miguel_Angel_Baeyens — Wed, 25 Jul 2012 11:25:24 GMT

Hi,

Yes, both make sense. In the first case when using Peek() you are not specifying any table, so Peek() will return the last distinct value in the field 'Users', as you will see the values of the field in a listbox. Instead, this line will return as expected (two different values):

LET arg = Peek('Users', $(i), 'tblusers');

FieldValue() returns the value with that index number sorted by load order, regardless whether the value is or is not distinct or unique.

Hope that helps.

Miguel

Re: Simple For...Next Not Working

Qvmaster2019 — Wed, 25 Jul 2012 11:27:52 GMT

Thanks a lot!