topic Re: expression to pull avg acv greater than zero in QlikView https://community.qlik.com/t5/QlikView/expression-to-pull-avg-acv-greater-than-zero/m-p/979852#M645371 <HTML><HEAD></HEAD><BODY><P>Awesome <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>I am glad I was able to help</P></BODY></HTML> Wed, 28 Oct 2015 13:59:38 GMT sunny_talwar 2015-10-28T13:59:38Z expression to pull avg acv greater than zero https://community.qlik.com/t5/QlikView/expression-to-pull-avg-acv-greater-than-zero/m-p/979849#M645368 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P>fairly new to the qlik community<IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> trying to figure out an expression to pull our field 'acv extended price' when it's greater than zero. Any thoughts?</P></BODY></HTML> Wed, 28 Oct 2015 11:58:35 GMT https://community.qlik.com/t5/QlikView/expression-to-pull-avg-acv-greater-than-zero/m-p/979849#M645368 2015-10-28T11:58:35Z Re: expression to pull avg acv greater than zero https://community.qlik.com/t5/QlikView/expression-to-pull-avg-acv-greater-than-zero/m-p/979850#M645369 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>=Sum(<SPAN style="color: #ff0000;">{&lt;<SPAN style="font-size: 13.3333px;">[acv extended price] = {'&gt;0'}</SPAN>&gt;}</SPAN>[acv extended price]) </STRONG>or</P><P></P><P><SPAN style="color: #575757;"><STRONG>=Sum(If(</STRONG></SPAN><STRONG style="color: #ff0000; font-size: 13.3333px;"><STRONG style="color: #575757;">[acv extended price] &gt; 0, </STRONG><STRONG style=": ; color: #575757; font-size: 13.3333px;"><STRONG>[acv extended price], 0))</STRONG></STRONG></STRONG></P></BODY></HTML> Wed, 28 Oct 2015 13:45:53 GMT https://community.qlik.com/t5/QlikView/expression-to-pull-avg-acv-greater-than-zero/m-p/979850#M645369 sunny_talwar 2015-10-28T13:45:53Z Re: expression to pull avg acv greater than zero https://community.qlik.com/t5/QlikView/expression-to-pull-avg-acv-greater-than-zero/m-p/979851#M645370 <HTML><HEAD></HEAD><BODY><P>thank you very much! Makes sense and worked great!</P></BODY></HTML> Wed, 28 Oct 2015 13:52:22 GMT https://community.qlik.com/t5/QlikView/expression-to-pull-avg-acv-greater-than-zero/m-p/979851#M645370 2015-10-28T13:52:22Z Re: expression to pull avg acv greater than zero https://community.qlik.com/t5/QlikView/expression-to-pull-avg-acv-greater-than-zero/m-p/979852#M645371 <HTML><HEAD></HEAD><BODY><P>Awesome <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>I am glad I was able to help</P></BODY></HTML> Wed, 28 Oct 2015 13:59:38 GMT https://community.qlik.com/t5/QlikView/expression-to-pull-avg-acv-greater-than-zero/m-p/979852#M645371 sunny_talwar 2015-10-28T13:59:38Z