topic How to split monthly volume for two days within one month? in QlikView https://community.qlik.com/t5/QlikView/How-to-split-monthly-volume-for-two-days-within-one-month/m-p/459232#M698156 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I am trying to build a forecast report for accounts receivables. My sales forecast is only on monthly level and I would need to split that at least to two pieces. What kind of script I would need to write in following scenario:</P><P></P><P>Original table:</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Product code</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Sales forecast March</STRONG></SPAN></TH></TR><TR><TD>11111</TD><TD>10000</TD></TR><TR><TD>22222</TD><TD>10000</TD></TR><TR><TD>33333</TD><TD>10000</TD></TR></TBODY></TABLE><P></P><P>Desired table: 60% in 10th day and 40% in 20th day</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Product code</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Sales forecast in March 10th</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Sales forecast in March 20th</STRONG></SPAN></TH></TR><TR><TD>11111</TD><TD>6000</TD><TD>4000</TD></TR><TR><TD>22222</TD><TD>6000</TD><TD>4000</TD></TR><TR><TD>33333</TD><TD>6000</TD><TD>4000</TD></TR></TBODY></TABLE><P></P><P></P><P>Thanks</P><P>Regards</P><P>Janne</P></BODY></HTML> Thu, 21 Feb 2013 15:48:09 GMT 2013-02-21T15:48:09Z How to split monthly volume for two days within one month? https://community.qlik.com/t5/QlikView/How-to-split-monthly-volume-for-two-days-within-one-month/m-p/459232#M698156 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I am trying to build a forecast report for accounts receivables. My sales forecast is only on monthly level and I would need to split that at least to two pieces. What kind of script I would need to write in following scenario:</P><P></P><P>Original table:</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Product code</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Sales forecast March</STRONG></SPAN></TH></TR><TR><TD>11111</TD><TD>10000</TD></TR><TR><TD>22222</TD><TD>10000</TD></TR><TR><TD>33333</TD><TD>10000</TD></TR></TBODY></TABLE><P></P><P>Desired table: 60% in 10th day and 40% in 20th day</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Product code</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Sales forecast in March 10th</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Sales forecast in March 20th</STRONG></SPAN></TH></TR><TR><TD>11111</TD><TD>6000</TD><TD>4000</TD></TR><TR><TD>22222</TD><TD>6000</TD><TD>4000</TD></TR><TR><TD>33333</TD><TD>6000</TD><TD>4000</TD></TR></TBODY></TABLE><P></P><P></P><P>Thanks</P><P>Regards</P><P>Janne</P></BODY></HTML> Thu, 21 Feb 2013 15:48:09 GMT https://community.qlik.com/t5/QlikView/How-to-split-monthly-volume-for-two-days-within-one-month/m-p/459232#M698156 2013-02-21T15:48:09Z