Calculating fields based on a previous field

ttomasz_pl — Wed, 25 Nov 2020 16:16:04 GMT

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,

Re: Calculating fields based on a previous field

andrespa — Tue, 31 May 2016 08:12:32 GMT

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

topic Re: Calculating fields based on a previous field in QlikView

Calculating fields based on a previous field

Re: Calculating fields based on a previous field