topic values should be same, if there is no value in change for missing months. in Qlik Learning Discussions

values should be same, if there is no value in change for missing months.

kavita25 — Fri, 05 Dec 2014 06:12:16 GMT

Please help me with the solution where the where stock should be same for every month for material M001 till there is no movement in stock(QTY).

In ex. there is no movement in stock from april month but still i want to see the previous updated stock till the current month as shown in table1:

Year	Month	Material	Qty	Cost
2014	Aug	M001	2	1204
2014	Sep	M001	2	1204
2014	Oct	M001	2	1204
2014	Nov	M001	2	1204
2014	Dec	M001	2	1204

but i am getting output as table 2 .when i select material M001 it show only Aug data for 2014 which is 2.i have tried peek and previous function. but still not getting correct output.

Year	Month	Material	Qty	Cost
2014	Aug	M001	2	1204

Note:The values are not updated in the database itself.

Re: values should be same, if there is no value in change for missing months.

Gysbert_Wassenaar — Fri, 05 Dec 2014 11:26:58 GMT

See this blog post: How to populate a sparsely populated field

Re: Re: values should be same, if there is no value in change for missing months.

kavita25 — Fri, 05 Dec 2014 12:38:56 GMT

Hello,

Thanks for the reply.But unfortunately in my case, there's no date.

I have tried with possible solutions but couldn't achieve yet.

Kindly see the attachment and revert back.

Thank You!! !