topic Re: Average Issue in QlikView https://community.qlik.com/t5/QlikView/Average-Issue/m-p/625300#M1112549 <HTML><HEAD></HEAD><BODY><P>How can ifnore zeros if want to calculate (CMP_Date - pre)</P><P></P><P>if ( State_Code = 'CMP' , timestamp ( Txn_Date ), null ()) as [CMP_Date] </P><P></P><P>if ( State_Code = 'CMP' ,( Previous ( CMP_Date )), '' ) as pre </P></BODY></HTML> Mon, 24 Feb 2014 17:18:44 GMT 2014-02-24T17:18:44Z Average Issue https://community.qlik.com/t5/QlikView/Average-Issue/m-p/625298#M1112547 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a code which gives me correct stats application by application but when I take average it also counts zero values therefore average decreases than actual should be. How can I resolve this issue either by cod eor presentation? </P></BODY></HTML> Mon, 24 Feb 2014 17:01:17 GMT https://community.qlik.com/t5/QlikView/Average-Issue/m-p/625298#M1112547 2014-02-24T17:01:17Z Re: Average Issue https://community.qlik.com/t5/QlikView/Average-Issue/m-p/625299#M1112548 <HTML><HEAD></HEAD><BODY><P>You could try... avg({&lt;<EM>Yourfieldname &lt;&gt; 0</EM>&gt; <EM>Yourfieldname</EM>})&nbsp; and/or make sure suppress zero-values is checked on the Presentation tab.</P></BODY></HTML> Mon, 24 Feb 2014 17:08:59 GMT https://community.qlik.com/t5/QlikView/Average-Issue/m-p/625299#M1112548 2014-02-24T17:08:59Z Re: Average Issue https://community.qlik.com/t5/QlikView/Average-Issue/m-p/625300#M1112549 <HTML><HEAD></HEAD><BODY><P>How can ifnore zeros if want to calculate (CMP_Date - pre)</P><P></P><P>if ( State_Code = 'CMP' , timestamp ( Txn_Date ), null ()) as [CMP_Date] </P><P></P><P>if ( State_Code = 'CMP' ,( Previous ( CMP_Date )), '' ) as pre </P></BODY></HTML> Mon, 24 Feb 2014 17:18:44 GMT https://community.qlik.com/t5/QlikView/Average-Issue/m-p/625300#M1112549 2014-02-24T17:18:44Z