for loop - help needed

Tue, 20 Aug 2013 07:58:41 GMT

Hi,

i am not expert on loops - could you please help me?

Attached i am sending a qvw with data and also xlsx spreadsheet.

Data i have is:

period key status info

2013 08 A revised abc

2013 08 B revised def

2013 08 C compl ghi

2013 07 A other jkl

2013 07 B compl mno

2013 07 C compl prs

2013 06 A compl tuw

2013 06 B compl xyz

Now i would like to create a loop file that would:

1) check if in the line status is 'revised'

2) if yes - another loop is needed to go to a latest period where status for the same key was 'compl'

3) create a new column e.g. info2 where the value will be either the same as in column info (in case status is other than 'revised') or that would give value from info column from the latest period where the same key had status 'compl' .

So i would like to have:

period key status info info2

2013 08 A revised abc tuw

2013 08 B revised def mno

2013 08 C compl ghi ghi

2013 07 A other jkl jkl

2013 07 B compl mno mno

2013 07 C compl prs prs

2013 06 A compl tuw tuw

2013 06 B compl xyz xyz

I'll be grateful for help. Thanks

Re: for loop - help needed

Gysbert_Wassenaar — Tue, 20 Aug 2013 17:39:37 GMT

You don't need a loop. You can do it with regular load statements. See attached qvw. Note, the inline load is just an example to load some example date. Replace it with your load statement.

Re: for loop - help needed

Wed, 21 Aug 2013 07:12:11 GMT

Hi G,

thanks for answer.

yes, i managed to obtain my result with normal load statements as well, just thought that loop would be more efficient in this case.
J.

topic Re: for loop - help needed in QlikView

for loop - help needed

Re: for loop - help needed

Re: for loop - help needed