Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.