Looping over table rows and update a field

[#1]

Hi all,

I need to create something like this. Can you help me?

No	NoBefore	Price
14	10
10	7
7		1200
12	8
8		500
13		1700

In the first run select MIN of No.Before in that case it is 7.

Then Select Price in row where No.=7, it is 1200 and give this to row where No.Before=7.

And the table look like this:

No	NoBefore	Price
14	10
10	7	1200
7		1200
12	8
8		500
13		1700

In the second run select the second MIN of No.Before in that case is 8.

Then Select Price in row where No.=8, it is 500 and give this to row where No.Before=8.

And the table look like this:

No	NoBefore	Price
14	10
10	7	1200
7		1200
12	8	500
8		500
13		1700

And so on.

Finally get this result:

No	NoBeore	Price
14	10	1200
10	7	1200
7		1200
12	8	500
8		500
13		1700

Please help me how can I create this in Qlikview!

Many thanks!

[Gysbert_Wassenaar · Accepted solution]

See attached example.

[#3]

Wow! Excellent!

Thank you very much!

If you are in Hungary, I will owe you a beer!

Thanks again!