QlikView “Copy Down” Previous NonZero Values

[#1]

I have a QlikView application of Employees, months and salaries (along with other stuff, obviously). I have also a column that tells me the percentage pay movement this month.

I'd like to, in the Load Script, "copy down" this data so that I can find the most recent previous pay percentage increase and the month (please see the picture).

So I effectively have the yellow data, and want to generate the red data, for each employee ID. I'm not massively fussed on EXACTLY what the non-zero values are - i.e. if they're zero or NULL or anything.

Should probably note, this isn't my Excel/CSV file, this is the actual QlikView table - due to the way our data comes out of the source system, we have to calculate basic pay movements in the load script (along with other stuff) using 3 or 4 temporary tables, then load them all together.

[petter]

You can employ the Peek()-function along with If() and sorting the table you read from on date ascending. I give this comment from a phone so I cant give you a full example....

[callmedaddy]

Any solution yet?