Help with table

jumiprado — Thu, 18 Aug 2016 14:21:44 GMT

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!

Re: Help with table

adamdavi3s — Thu, 18 Aug 2016 14:24:23 GMT

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.

topic Re: Help with table in QlikView

Help with table

Re: Help with table