Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone.
I have a table with demand information. It has historical "pictures". In the example below I've extracted a info in day feb 17th, and other picture in feb 20th. In order to keep demand historical changes.
So in each Extract_Date we can have multiples orders for many different materials in many different necessities dates for many different customers.
I need to simulate, for example: "Based on Extract-date feb20th, What happens to my volume if we postpone 30 days the orders for customer C3?"
Just to make it clear, below a demo:
Let's take the Anticipate example ... I've change the dates in 'Necessity Date' (60 days earlier) just for Customer C3, considering the data extraction of feb 20th. Note that, in Anticipate example the material volume (blue) move to left.
Table columns info:
EXTRACT_DATE - date that all data was extracted from ERP
Customer_Group - self explained
Customer_Code - code of the customer
Material_Code - code of the material ordered by the customer
DEMAND_FROM - region of customer
QUANTITY - self explained
DEMAND_DATE - necessity date of the material ordered
Almost forgot, It's in Qlik Sense.
Thanks!