topic Open Order Changes Over Time in QlikView https://community.qlik.com/t5/QlikView/Open-Order-Changes-Over-Time/m-p/809821#M285840 <HTML><HEAD></HEAD><BODY><P>Hi Everybody,</P><P></P><P>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.</P><P></P><P>For example, I have the data set below. As of 10/30 in the <STRONG>Datestamp</STRONG> field, the Dollars for November (using the <STRONG>Expected_Ship_Month</STRONG> 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 <STRONG>Expected_Ship_Date</STRONG> field and the job moved into December, and job_4 changed from 12/01 to 11/30.</P><P></P><P>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 <STRONG>Datestamp </STRONG>field, and then the month (<STRONG>Expected_Ship_Month</STRONG>) for which they would like to see the sales.</P><P></P><P>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.</P><P></P><P>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?</P><P></P><P>Thanks!</P><P></P><P>Justin</P><P></P><TABLE><TBODY><TR><TD>RecNo()</TD><TD>Job_Number</TD><TD>Datestamp</TD><TD>Expected_Ship_Date</TD><TD>Expected_Ship_Month</TD><TD>Dollars</TD></TR><TR><TD>1</TD><TD>job_1</TD><TD>10/30/2014</TD><TD>11/01/2014</TD><TD>11/01/2014</TD><TD>100000</TD></TR><TR><TD>2</TD><TD>job_1</TD><TD>10/31/2014</TD><TD>11/01/2014</TD><TD>11/01/2014</TD><TD>100000</TD></TR><TR><TD>3</TD><TD>job_1</TD><TD>11/01/2014</TD><TD>11/01/2014</TD><TD>11/01/2014</TD><TD>100000</TD></TR><TR><TD>4</TD><TD>job_1</TD><TD>11/02/2014</TD><TD>11/10/2014</TD><TD>11/01/2014</TD><TD>100000</TD></TR><TR><TD>5</TD><TD>job_2</TD><TD>10/30/2014</TD><TD>11/04/2014</TD><TD>11/01/2014</TD><TD>250000</TD></TR><TR><TD>6</TD><TD>job_2</TD><TD>10/31/2014</TD><TD>11/04/2014</TD><TD>11/01/2014</TD><TD>250000</TD></TR><TR><TD>7</TD><TD>job_2</TD><TD>11/01/2014</TD><TD>11/04/2014</TD><TD>11/01/2014</TD><TD>250000</TD></TR><TR><TD>8</TD><TD>job_2</TD><TD>11/02/2014</TD><TD>11/04/2014</TD><TD>11/01/2014</TD><TD>250000</TD></TR><TR><TD>9</TD><TD>job_2</TD><TD>11/03/2014</TD><TD>11/04/2014</TD><TD>11/01/2014</TD><TD>250000</TD></TR><TR><TD>10</TD><TD>job_3</TD><TD>10/29/2014</TD><TD>11/30/2014</TD><TD>11/01/2014</TD><TD>500000</TD></TR><TR><TD>11</TD><TD>job_3</TD><TD>10/30/2014</TD><TD>11/30/2014</TD><TD>11/01/2014</TD><TD>500000</TD></TR><TR><TD>12</TD><TD>job_3</TD><TD>10/31/2014</TD><TD>12/15/2014</TD><TD>12/01/2014</TD><TD>500000</TD></TR><TR><TD>13</TD><TD>job_4</TD><TD>10/30/2014</TD><TD>12/01/2014</TD><TD>12/01/2014</TD><TD>75000</TD></TR><TR><TD>14</TD><TD>job_4</TD><TD>10/31/2014</TD><TD>11/30/2014</TD><TD>11/01/2014</TD><TD>75000</TD></TR><TR><TD>15</TD><TD>job_4</TD><TD>11/01/2014</TD><TD>11/30/2014</TD><TD>11/01/2014</TD><TD>75000</TD></TR><TR><TD>16</TD><TD>job_4</TD><TD>11/02/2014</TD><TD>11/30/2014</TD><TD>11/01/2014</TD><TD>75000</TD></TR></TBODY></TABLE></BODY></HTML> Mon, 24 Nov 2014 19:53:40 GMT 2014-11-24T19:53:40Z Open Order Changes Over Time https://community.qlik.com/t5/QlikView/Open-Order-Changes-Over-Time/m-p/809821#M285840 <HTML><HEAD></HEAD><BODY><P>Hi Everybody,</P><P></P><P>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.</P><P></P><P>For example, I have the data set below. As of 10/30 in the <STRONG>Datestamp</STRONG> field, the Dollars for November (using the <STRONG>Expected_Ship_Month</STRONG> 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 <STRONG>Expected_Ship_Date</STRONG> field and the job moved into December, and job_4 changed from 12/01 to 11/30.</P><P></P><P>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 <STRONG>Datestamp </STRONG>field, and then the month (<STRONG>Expected_Ship_Month</STRONG>) for which they would like to see the sales.</P><P></P><P>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.</P><P></P><P>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?</P><P></P><P>Thanks!</P><P></P><P>Justin</P><P></P><TABLE><TBODY><TR><TD>RecNo()</TD><TD>Job_Number</TD><TD>Datestamp</TD><TD>Expected_Ship_Date</TD><TD>Expected_Ship_Month</TD><TD>Dollars</TD></TR><TR><TD>1</TD><TD>job_1</TD><TD>10/30/2014</TD><TD>11/01/2014</TD><TD>11/01/2014</TD><TD>100000</TD></TR><TR><TD>2</TD><TD>job_1</TD><TD>10/31/2014</TD><TD>11/01/2014</TD><TD>11/01/2014</TD><TD>100000</TD></TR><TR><TD>3</TD><TD>job_1</TD><TD>11/01/2014</TD><TD>11/01/2014</TD><TD>11/01/2014</TD><TD>100000</TD></TR><TR><TD>4</TD><TD>job_1</TD><TD>11/02/2014</TD><TD>11/10/2014</TD><TD>11/01/2014</TD><TD>100000</TD></TR><TR><TD>5</TD><TD>job_2</TD><TD>10/30/2014</TD><TD>11/04/2014</TD><TD>11/01/2014</TD><TD>250000</TD></TR><TR><TD>6</TD><TD>job_2</TD><TD>10/31/2014</TD><TD>11/04/2014</TD><TD>11/01/2014</TD><TD>250000</TD></TR><TR><TD>7</TD><TD>job_2</TD><TD>11/01/2014</TD><TD>11/04/2014</TD><TD>11/01/2014</TD><TD>250000</TD></TR><TR><TD>8</TD><TD>job_2</TD><TD>11/02/2014</TD><TD>11/04/2014</TD><TD>11/01/2014</TD><TD>250000</TD></TR><TR><TD>9</TD><TD>job_2</TD><TD>11/03/2014</TD><TD>11/04/2014</TD><TD>11/01/2014</TD><TD>250000</TD></TR><TR><TD>10</TD><TD>job_3</TD><TD>10/29/2014</TD><TD>11/30/2014</TD><TD>11/01/2014</TD><TD>500000</TD></TR><TR><TD>11</TD><TD>job_3</TD><TD>10/30/2014</TD><TD>11/30/2014</TD><TD>11/01/2014</TD><TD>500000</TD></TR><TR><TD>12</TD><TD>job_3</TD><TD>10/31/2014</TD><TD>12/15/2014</TD><TD>12/01/2014</TD><TD>500000</TD></TR><TR><TD>13</TD><TD>job_4</TD><TD>10/30/2014</TD><TD>12/01/2014</TD><TD>12/01/2014</TD><TD>75000</TD></TR><TR><TD>14</TD><TD>job_4</TD><TD>10/31/2014</TD><TD>11/30/2014</TD><TD>11/01/2014</TD><TD>75000</TD></TR><TR><TD>15</TD><TD>job_4</TD><TD>11/01/2014</TD><TD>11/30/2014</TD><TD>11/01/2014</TD><TD>75000</TD></TR><TR><TD>16</TD><TD>job_4</TD><TD>11/02/2014</TD><TD>11/30/2014</TD><TD>11/01/2014</TD><TD>75000</TD></TR></TBODY></TABLE></BODY></HTML> Mon, 24 Nov 2014 19:53:40 GMT https://community.qlik.com/t5/QlikView/Open-Order-Changes-Over-Time/m-p/809821#M285840 2014-11-24T19:53:40Z