Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kavita25
Partner - Specialist
Partner - Specialist

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

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.


2 Replies
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
kavita25
Partner - Specialist
Partner - Specialist
Author

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!! !