Help with table

[jumiprado]

Hey guys i have this problem:

I have a table like this:

Client	Period	Money
Client_1	201601	100
Client_2	201601	50
Client_3	201601	70
Client_1	201602	110
Client_2	201602	60
Client_1	201603	120
Client_3	201603	70

And i need to generate a table where for all periods take the money and if i dont have money for that period, repeat the last money, something like this:

Client	Period	Money
Client_1	201601	100
Client_2	201601	50
Client_3	201601	70
Client_1	201602	110
Client_2	201602	60
Client_3	201602	70
Client_1	201603	120
Client_2	201603	60
Client_3	201603	70

Thanks you in advanced!

[adamdavi3s]

There is an excellent thread on this here

Generating Missing Data In QlikView

Please remember to mark this as helpful or the correct answer if I have helped you or answered your question.