topic Need help for expression in QlikView https://community.qlik.com/t5/QlikView/Need-help-for-expression/m-p/269426#M101066 <HTML><HEAD></HEAD><BODY><P>Hi I have this pivot table after final manipulation </P><P></P><P></P><TABLE border="0" cellspacing="0" frame="void" rules="none"><TBODY><TR><TD align="left" bgcolor="#ebebeb" height="17" style="border-bottom: #dcdcdc 1px solid; border-left: #dcdcdc 1px solid; border-top: #dcdcdc 3px solid; border-right: #dcdcdc 3px solid;" width="78"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">ITEM CODE</STRONG></TD><TD align="left" bgcolor="#ebebeb" style="border-bottom: #dcdcdc 1px solid; border-left: #dcdcdc 1px solid; border-top: #dcdcdc 3px solid; border-right: #dcdcdc 3px solid;" width="67"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">QUANTITY</STRONG></TD><TD align="left" bgcolor="#ebebeb" style="border-bottom: #dcdcdc 1px solid; border-left: #dcdcdc 1px solid; border-top: #dcdcdc 3px solid; border-right: #dcdcdc 3px solid;" width="67"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">PRICE</STRONG></TD><TD align="left" width="67"><BR /></TD></TR><TR><TD align="right" bgcolor="#ffffff" height="17" style="border: #dcdcdc 1px solid;"><SPAN style="font-family: Tahoma; color: #333333; font-size: 8pt;">1501</SPAN></TD><TD align="right">2</TD><TD align="right">0</TD><TD align="left"><BR /></TD></TR><TR><TD align="right" bgcolor="#ffffff" height="17" style="border: #dcdcdc 1px solid;"><SPAN style="font-family: Tahoma; color: #333333; font-size: 8pt;">1502</SPAN></TD><TD align="right">1</TD><TD align="right">0</TD><TD align="left"><BR /></TD></TR><TR><TD align="right" bgcolor="#ffffff" height="17" style="border: #dcdcdc 1px solid;"><SPAN style="font-family: Tahoma; color: #333333; font-size: 8pt;">1501</SPAN></TD><TD align="right">2</TD><TD align="right">1000</TD><TD align="left"><BR /></TD></TR><TR><TD align="right" bgcolor="#ffffff" height="17" style="border: #dcdcdc 1px solid;"><SPAN style="font-family: Tahoma; color: #333333; font-size: 8pt;">1502</SPAN></TD><TD align="right">5</TD><TD align="right">100</TD><TD align="left"><BR /></TD></TR></TBODY></TABLE><P></P><P>i have to achive this </P><P></P><TABLE border="0" cellspacing="0" frame="void" rules="none"><TBODY><TR><TD align="left" bgcolor="#ebebeb" height="17" style="border-bottom: #dcdcdc 1px solid; border-left: #dcdcdc 1px solid; border-top: #dcdcdc 3px solid; border-right: #dcdcdc 3px solid;" width="78"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">ITEM CODE</STRONG></TD><TD align="left" bgcolor="#ebebeb" style="border-bottom: #dcdcdc 1px solid; border-left: #dcdcdc 1px solid; border-top: #dcdcdc 3px solid; border-right: #dcdcdc 3px solid;" width="67"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">FOC Q</STRONG></TD><TD align="left" bgcolor="#ebebeb" style="border-bottom: #dcdcdc 1px solid; border-left: #dcdcdc 1px solid; border-top: #dcdcdc 3px solid; border-right: #dcdcdc 3px solid;" width="67"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">QUANTITY</STRONG></TD><TD align="left" bgcolor="#ebebeb" style="border-bottom: #dcdcdc 1px solid; border-left: #dcdcdc 1px solid; border-top: #dcdcdc 3px solid; border-right: #dcdcdc 3px solid;" width="67"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">PRICE</STRONG></TD><TD align="left" bgcolor="#ebebeb" style="border-bottom: #dcdcdc 1px solid; border-left: #dcdcdc 1px solid; border-top: #dcdcdc 3px solid; border-right: #dcdcdc 3px solid;" width="67"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">AVG PRICE</STRONG></TD><TD align="left" width="67"><BR /></TD></TR><TR><TD align="right" bgcolor="#ffffff" height="17" style="border: #dcdcdc 1px solid;"><SPAN style="font-family: Tahoma; color: #333333; font-size: 8pt;">1501</SPAN></TD><TD align="right">2</TD><TD align="right">2</TD><TD align="right">1000</TD><TD align="right">250</TD><TD align="left"><BR /></TD></TR><TR><TD align="right" bgcolor="#ffffff" height="17" style="border: #dcdcdc 1px solid;"><SPAN style="font-family: Tahoma; color: #333333; font-size: 8pt;">1502</SPAN></TD><TD align="right">1</TD><TD align="right">5</TD><TD align="right">100</TD><TD align="right">16.67</TD><TD align="left"><BR /></TD></TR></TBODY></TABLE><P><BR />please tell me the exprssion used for </P><TABLE border="0" cellspacing="0" frame="void" rules="none"><TBODY><TR><TD align="left" bgcolor="#ebebeb" style="border-bottom: #dcdcdc 1px solid; border-left: #dcdcdc 1px solid; border-top: #dcdcdc 3px solid; border-right: #dcdcdc 3px solid;" width="67"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">FOC Q</STRONG></TD><TD align="left" bgcolor="#ebebeb" style="border-bottom: #dcdcdc 1px solid; border-left: #dcdcdc 1px solid; border-top: #dcdcdc 3px solid; border-right: #dcdcdc 3px solid;" width="67"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">QUANTITY</STRONG></TD><TD align="left" bgcolor="#ebebeb" style="border-bottom: #dcdcdc 1px solid; border-left: #dcdcdc 1px solid; border-top: #dcdcdc 3px solid; border-right: #dcdcdc 3px solid;" width="67"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">PRICE</STRONG></TD><TD align="left" bgcolor="#ebebeb" style="border-bottom: #dcdcdc 1px solid; border-left: #dcdcdc 1px solid; border-top: #dcdcdc 3px solid; border-right: #dcdcdc 3px solid;" width="67"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">AVG PRICE</STRONG></TD></TR></TBODY></TABLE></BODY></HTML> Thu, 12 Jan 2012 10:11:33 GMT 2012-01-12T10:11:33Z Need help for expression https://community.qlik.com/t5/QlikView/Need-help-for-expression/m-p/269426#M101066 <HTML><HEAD></HEAD><BODY><P>Hi I have this pivot table after final manipulation </P><P></P><P></P><TABLE border="0" cellspacing="0" frame="void" rules="none"><TBODY><TR><TD align="left" bgcolor="#ebebeb" height="17" style="border-bottom: #dcdcdc 1px solid; border-left: #dcdcdc 1px solid; border-top: #dcdcdc 3px solid; border-right: #dcdcdc 3px solid;" width="78"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">ITEM CODE</STRONG></TD><TD align="left" bgcolor="#ebebeb" style="border-bottom: #dcdcdc 1px solid; border-left: #dcdcdc 1px solid; border-top: #dcdcdc 3px solid; border-right: #dcdcdc 3px solid;" width="67"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">QUANTITY</STRONG></TD><TD align="left" bgcolor="#ebebeb" style="border-bottom: #dcdcdc 1px solid; border-left: #dcdcdc 1px solid; border-top: #dcdcdc 3px solid; border-right: #dcdcdc 3px solid;" width="67"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">PRICE</STRONG></TD><TD align="left" width="67"><BR /></TD></TR><TR><TD align="right" bgcolor="#ffffff" height="17" style="border: #dcdcdc 1px solid;"><SPAN style="font-family: Tahoma; color: #333333; font-size: 8pt;">1501</SPAN></TD><TD align="right">2</TD><TD align="right">0</TD><TD align="left"><BR /></TD></TR><TR><TD align="right" bgcolor="#ffffff" height="17" style="border: #dcdcdc 1px solid;"><SPAN style="font-family: Tahoma; color: #333333; font-size: 8pt;">1502</SPAN></TD><TD align="right">1</TD><TD align="right">0</TD><TD align="left"><BR /></TD></TR><TR><TD align="right" bgcolor="#ffffff" height="17" style="border: #dcdcdc 1px solid;"><SPAN style="font-family: Tahoma; color: #333333; font-size: 8pt;">1501</SPAN></TD><TD align="right">2</TD><TD align="right">1000</TD><TD align="left"><BR /></TD></TR><TR><TD align="right" bgcolor="#ffffff" height="17" style="border: #dcdcdc 1px solid;"><SPAN style="font-family: Tahoma; color: #333333; font-size: 8pt;">1502</SPAN></TD><TD align="right">5</TD><TD align="right">100</TD><TD align="left"><BR /></TD></TR></TBODY></TABLE><P></P><P>i have to achive this </P><P></P><TABLE border="0" cellspacing="0" frame="void" rules="none"><TBODY><TR><TD align="left" bgcolor="#ebebeb" height="17" style="border-bottom: #dcdcdc 1px solid; border-left: #dcdcdc 1px solid; border-top: #dcdcdc 3px solid; border-right: #dcdcdc 3px solid;" width="78"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">ITEM CODE</STRONG></TD><TD align="left" bgcolor="#ebebeb" style="border-bottom: #dcdcdc 1px solid; border-left: #dcdcdc 1px solid; border-top: #dcdcdc 3px solid; border-right: #dcdcdc 3px solid;" width="67"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">FOC Q</STRONG></TD><TD align="left" bgcolor="#ebebeb" style="border-bottom: #dcdcdc 1px solid; border-left: #dcdcdc 1px solid; border-top: #dcdcdc 3px solid; border-right: #dcdcdc 3px solid;" width="67"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">QUANTITY</STRONG></TD><TD align="left" bgcolor="#ebebeb" style="border-bottom: #dcdcdc 1px solid; border-left: #dcdcdc 1px solid; border-top: #dcdcdc 3px solid; border-right: #dcdcdc 3px solid;" width="67"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">PRICE</STRONG></TD><TD align="left" bgcolor="#ebebeb" style="border-bottom: #dcdcdc 1px solid; border-left: #dcdcdc 1px solid; border-top: #dcdcdc 3px solid; border-right: #dcdcdc 3px solid;" width="67"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">AVG PRICE</STRONG></TD><TD align="left" width="67"><BR /></TD></TR><TR><TD align="right" bgcolor="#ffffff" height="17" style="border: #dcdcdc 1px solid;"><SPAN style="font-family: Tahoma; color: #333333; font-size: 8pt;">1501</SPAN></TD><TD align="right">2</TD><TD align="right">2</TD><TD align="right">1000</TD><TD align="right">250</TD><TD align="left"><BR /></TD></TR><TR><TD align="right" bgcolor="#ffffff" height="17" style="border: #dcdcdc 1px solid;"><SPAN style="font-family: Tahoma; color: #333333; font-size: 8pt;">1502</SPAN></TD><TD align="right">1</TD><TD align="right">5</TD><TD align="right">100</TD><TD align="right">16.67</TD><TD align="left"><BR /></TD></TR></TBODY></TABLE><P><BR />please tell me the exprssion used for </P><TABLE border="0" cellspacing="0" frame="void" rules="none"><TBODY><TR><TD align="left" bgcolor="#ebebeb" style="border-bottom: #dcdcdc 1px solid; border-left: #dcdcdc 1px solid; border-top: #dcdcdc 3px solid; border-right: #dcdcdc 3px solid;" width="67"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">FOC Q</STRONG></TD><TD align="left" bgcolor="#ebebeb" style="border-bottom: #dcdcdc 1px solid; border-left: #dcdcdc 1px solid; border-top: #dcdcdc 3px solid; border-right: #dcdcdc 3px solid;" width="67"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">QUANTITY</STRONG></TD><TD align="left" bgcolor="#ebebeb" style="border-bottom: #dcdcdc 1px solid; border-left: #dcdcdc 1px solid; border-top: #dcdcdc 3px solid; border-right: #dcdcdc 3px solid;" width="67"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">PRICE</STRONG></TD><TD align="left" bgcolor="#ebebeb" style="border-bottom: #dcdcdc 1px solid; border-left: #dcdcdc 1px solid; border-top: #dcdcdc 3px solid; border-right: #dcdcdc 3px solid;" width="67"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">AVG PRICE</STRONG></TD></TR></TBODY></TABLE></BODY></HTML> Thu, 12 Jan 2012 10:11:33 GMT https://community.qlik.com/t5/QlikView/Need-help-for-expression/m-p/269426#M101066 2012-01-12T10:11:33Z Need help for expression https://community.qlik.com/t5/QlikView/Need-help-for-expression/m-p/269427#M101067 <HTML><HEAD></HEAD><BODY><P> Hi Pramod,</P><P>You can achieve this by:</P><P>FOC Q= Sum(If(Price=0,Quantity));</P><P>Quantity=Sum(If(Price&lt;&gt;0,Quantity));</P><P>Price=Sum(Price);</P><P>Avg=Sum(Price)/Sum(Quantity)</P></BODY></HTML> Thu, 12 Jan 2012 10:24:09 GMT https://community.qlik.com/t5/QlikView/Need-help-for-expression/m-p/269427#M101067 vijay_iitkgp 2012-01-12T10:24:09Z