topic Re: looking for a stock example in QlikView

looking for a stock example

amien — Thu, 13 Jun 2013 23:22:21 GMT

anyone got a stock example for me? I have the current stock postion of a certain material. Plus i have all the movements.

See it needs to be calculated backwards.

Example:

Material , Date , Current/Movement , Value

AAAA , 14/02/2013 , Current , 1000

AAAA , 12/02/2013 , Movement , -500

AAAA , 11/02/2013, Movement , 200

So my output tables should be:

AAAA , 14/02/2013 , 1000

AAAA , 13/02/2013 , 1000

AAAA , 12/02/2013 , 1500

AAAA , 11/02/2013 , 1300

etc

I'm not looking for an expression because of the number of rows to process.

Thanks in advanced

Re: looking for a stock example

Gysbert_Wassenaar — Fri, 14 Jun 2013 12:13:02 GMT

See attached example

Re: looking for a stock example

amien — Mon, 17 Jun 2013 21:00:05 GMT

Gysbert, Thanks for your help. Nice script, but i have a question.

Why doesn't it work when i have 2 rows for movements within the same day? see example

Re: looking for a stock example

Gysbert_Wassenaar — Tue, 18 Jun 2013 08:40:15 GMT

Because of the join. The gaps between dates will be filled for every movement on the date prior to the gap. You'll need to aggregate the movements first per date if you have more than one movement per date.

Re: looking for a stock example

amien — Tue, 18 Jun 2013 21:30:02 GMT

Excellent stuff Gysbert! .. works like a charm . Thanks