topic Wip Turnover crosstab format? in QlikView https://community.qlik.com/t5/QlikView/Wip-Turnover-crosstab-format/m-p/275789#M1190576 <HTML><HEAD></HEAD><BODY><P>I am not really sure how to go about doing this. I am basically familiar with expression writing, but not much.</P><P></P><P>We want to create a WIP(Work in process) turnover list, which shows the change in WIP per week. So it would show for each week, the total value open, and the total Count open. Fields I have available are Completed Date (blank if currently still open) Created date, and the cost field.</P><P></P><P>What I am not sure how to do is show for the past 30 days (weekly about 5 weeks) what the total count and value was. How do I carry the data over to the next week if it is still open?</P><P></P><P>Example:</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 06/12/2011&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 06/19/2011&nbsp;&nbsp;&nbsp; 06/26/2011&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 07/03/2011&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 07/10/2011</P><P>Value:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 16,282.23&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 98,343.69&nbsp;&nbsp;&nbsp;&nbsp; 140,140.61&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 855.28&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,089.21</P><P>Count:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 33&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 87&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 275&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 138&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13</P></BODY></HTML> Tue, 12 Jul 2011 20:04:53 GMT 2011-07-12T20:04:53Z Wip Turnover crosstab format? https://community.qlik.com/t5/QlikView/Wip-Turnover-crosstab-format/m-p/275789#M1190576 <HTML><HEAD></HEAD><BODY><P>I am not really sure how to go about doing this. I am basically familiar with expression writing, but not much.</P><P></P><P>We want to create a WIP(Work in process) turnover list, which shows the change in WIP per week. So it would show for each week, the total value open, and the total Count open. Fields I have available are Completed Date (blank if currently still open) Created date, and the cost field.</P><P></P><P>What I am not sure how to do is show for the past 30 days (weekly about 5 weeks) what the total count and value was. How do I carry the data over to the next week if it is still open?</P><P></P><P>Example:</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 06/12/2011&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 06/19/2011&nbsp;&nbsp;&nbsp; 06/26/2011&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 07/03/2011&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 07/10/2011</P><P>Value:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 16,282.23&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 98,343.69&nbsp;&nbsp;&nbsp;&nbsp; 140,140.61&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 855.28&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,089.21</P><P>Count:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 33&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 87&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 275&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 138&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13</P></BODY></HTML> Tue, 12 Jul 2011 20:04:53 GMT https://community.qlik.com/t5/QlikView/Wip-Turnover-crosstab-format/m-p/275789#M1190576 2011-07-12T20:04:53Z