Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

kavita25
Valued Contributor

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

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

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


talk is cheap, supply exceeds demand
kavita25
Valued Contributor

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

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

Community Browser