Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
MMachado
Contributor II
Contributor II

Simulate production volume based on date change

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.

tabletable

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:

simulsimul

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!

Labels (2)
0 Replies