Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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