Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Open Order Changes Over Time

Hi Everybody,

I'm trying to figure out a way where a user can pick two dates and see the expected sales and get a walk-across for those sales for the month they've chosen.

For example, I have the data set below. As of 10/30 in the Datestamp field, the Dollars for November (using the Expected_Ship_Month field) is $850,000. However, as of 10/31, the Dollars for November are now $425,000 since job_3 had a change to the Expected_Ship_Date field and the job moved into December, and job_4 changed from 12/01 to 11/30.

What I would like the end users to be able to do is choose three variables: a Beginning Date and an End Date using the Datestamp field, and then the month (Expected_Ship_Month) for which they would like to see the sales.

The difficult part is not getting the beginning and ending sales but in trying to explain which orders got delayed or which orders shipped early.

Anyone have any ideas on how to get a formula showing what jobs got pushed out into the next month and also a separate expression to show what jobs got pulled into the month?

Thanks!

Justin

RecNo()Job_NumberDatestampExpected_Ship_DateExpected_Ship_MonthDollars
1job_110/30/201411/01/201411/01/2014100000
2job_110/31/201411/01/201411/01/2014100000
3job_111/01/201411/01/201411/01/2014100000
4job_111/02/201411/10/201411/01/2014100000
5job_210/30/201411/04/201411/01/2014250000
6job_210/31/201411/04/201411/01/2014250000
7job_211/01/201411/04/201411/01/2014250000
8job_211/02/201411/04/201411/01/2014250000
9job_211/03/201411/04/201411/01/2014250000
10job_310/29/201411/30/201411/01/2014500000
11job_310/30/201411/30/201411/01/2014500000
12job_310/31/201412/15/201412/01/2014500000
13job_410/30/201412/01/201412/01/201475000
14job_410/31/201411/30/201411/01/201475000
15job_411/01/201411/30/201411/01/201475000
16job_411/02/201411/30/201411/01/201475000
0 Replies