Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
jumiprado
New Contributor III

Help with table

Hey guys i have this problem:

I have a table like this:

ClientPeriodMoney
Client_1201601100
Client_220160150
Client_320160170
Client_1201602110
Client_220160260
Client_1201603120
Client_320160370

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:

ClientPeriodMoney
Client_1201601100
Client_220160150
Client_320160170
Client_1201602110
Client_220160260
Client_320160270
Client_1201603120
Client_220160360
Client_320160370

Thanks you in advanced!

1 Reply
adamdavi3s
Honored Contributor

Re: Help with table

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.

Community Browser