Looping over table rows and update a field

Thu, 09 May 2013 09:20:20 GMT

Hi all,

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

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:

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:

And so on.

Finally get this result:

Please help me how can I create this in Qlikview!

Many thanks!

Re: Looping over table rows and update a field

Gysbert_Wassenaar — Thu, 09 May 2013 11:58:15 GMT

See attached example.

Thu, 09 May 2013 12:22:12 GMT

Wow! Excellent!

Thank you very much!

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

Thanks again!