Calculating fields based on a previous field

[ttomasz_pl]

Hi,

I'm quite new to Qlik and I have a problem.

I need to create a report regarding material consumption / production. I have material stock from one table, production orders from another and sales orders from another.

Now I need to put everything to one table and maintain time order and calculate predicted stock. For example:

Date	Element type	Qty	Stock
Today	Actual Stock	10	10
Next day	Production order	5	15
Next day	Sales order	-12	3
Next day	Production order	7	10

Another difficulty is that I need to have stock always in the first row.

Any hints on how to achieve this? Will be very grateful.

Regards,

TT

[andrespa]

Hi Tomasz, your question is very broad, the short answer is to please post somo sample qvw with some data and we might be able to help you through the transformation process.

Best regards,

Andrés