topic Re: How to do advance expression just like in excel? in QlikView https://community.qlik.com/t5/QlikView/How-to-do-advance-expression-just-like-in-excel/m-p/469805#M487349 <HTML><HEAD></HEAD><BODY><P>Hi Bill</P><P></P><P>check attached qvw file</P></BODY></HTML> Tue, 26 Feb 2013 08:58:28 GMT 2013-02-26T08:58:28Z How to do advance expression just like in excel? https://community.qlik.com/t5/QlikView/How-to-do-advance-expression-just-like-in-excel/m-p/469804#M487348 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I need help for my inventory cover analysis. Inorder to get the following:</P><P></P><P>FLOOR COVER: (InventoryBeginning-CurrentForecast)/NextForecast</P><P>INVENTORY BEGINNING: Previous InventoryBeginning + Previous Purchase Order - Previous Forecast</P><P></P><P>Look at the table below:</P><P></P><P>FORECAST</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="68" style="width: 225px; border: 1px solid rgb(0, 0, 0); height: 5px;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>MONTH YEAR</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>QTY</STRONG></SPAN></TH></TR><TR><TD>Jan 2012</TD><TD>100</TD></TR><TR><TD>Feb 2012</TD><TD>150</TD></TR><TR><TD>Mar 2012</TD><TD>130</TD></TR></TBODY></TABLE><P></P><P></P><P>PURCHASE ORDER</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="95" style="width: 222px; border: 1px solid rgb(0, 0, 0); height: 97px;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>MONTH YEAR</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>QTY</STRONG></SPAN></TH></TR><TR><TD>Jan 2012</TD><TD>120</TD></TR><TR><TD>Feb 2012</TD><TD>180</TD></TR><TR><TD>Mar 2012</TD><TD>135</TD></TR></TBODY></TABLE><P></P><P></P><P>AND BELOW SHOULD BE THE REPORT FORMAT</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><BR /></STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Jan 2012</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Feb 2012</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Mar 2012</STRONG></SPAN></TH></TR><TR><TD><SPAN style="color: #ff0000;"><STRONG>Inventory Beginning</STRONG></SPAN></TD><TD>300</TD><TD><SPAN style="color: #ff0000;">320</SPAN></TD><TD><SPAN style="color: #ff0000;">350</SPAN></TD></TR><TR><TD>Forecast</TD><TD>100</TD><TD>150</TD><TD>130</TD></TR><TR><TD>Purchase Order</TD><TD>120</TD><TD>180</TD><TD>135</TD></TR><TR><TD><STRONG style="color: #ff0000;">Floor Cover</STRONG></TD><TD><SPAN style="color: #ff0000;">1.33%</SPAN></TD><TD><SPAN style="color: #ff0000;">1.31%</SPAN></TD><TD><SPAN style="color: #ff0000;">-</SPAN></TD></TR></TBODY></TABLE><P></P><P>Any help with will be more appreciated.</P><P></P><P></P><P>Regards,</P><P>Bill</P></BODY></HTML> Tue, 26 Feb 2013 06:23:46 GMT https://community.qlik.com/t5/QlikView/How-to-do-advance-expression-just-like-in-excel/m-p/469804#M487348 2013-02-26T06:23:46Z Re: How to do advance expression just like in excel? https://community.qlik.com/t5/QlikView/How-to-do-advance-expression-just-like-in-excel/m-p/469805#M487349 <HTML><HEAD></HEAD><BODY><P>Hi Bill</P><P></P><P>check attached qvw file</P></BODY></HTML> Tue, 26 Feb 2013 08:58:28 GMT https://community.qlik.com/t5/QlikView/How-to-do-advance-expression-just-like-in-excel/m-p/469805#M487349 2013-02-26T08:58:28Z Re: How to do advance expression just like in excel? https://community.qlik.com/t5/QlikView/How-to-do-advance-expression-just-like-in-excel/m-p/469806#M487350 <HTML><HEAD></HEAD><BODY><P>Hi Pari Pari,</P><P></P><P>Thanks for your help, I'd been thinking for the solution. Great work!</P><P></P><P>Regards,</P><P>Bill</P></BODY></HTML> Tue, 26 Feb 2013 09:20:15 GMT https://community.qlik.com/t5/QlikView/How-to-do-advance-expression-just-like-in-excel/m-p/469806#M487350 2013-02-26T09:20:15Z