topic Help with Average condition in QlikView https://community.qlik.com/t5/QlikView/Help-with-Average-condition/m-p/198081#M57507 <HTML><HEAD></HEAD><BODY><P>Hi, I want to average a field where it meets a condition? How would I write the expression for this?</P><P>Below is what I currently have for the field expression:</P><P>Avg(Sales)</P><P>What I want it changed to is that it will Average the Sales field if the flag is equal to 1</P><P>Avg(Sales) where Flag =1</P><P></P><P>Thanks</P></BODY></HTML> Tue, 22 Jun 2010 23:40:36 GMT ivandrago 2010-06-22T23:40:36Z Help with Average condition https://community.qlik.com/t5/QlikView/Help-with-Average-condition/m-p/198081#M57507 <HTML><HEAD></HEAD><BODY><P>Hi, I want to average a field where it meets a condition? How would I write the expression for this?</P><P>Below is what I currently have for the field expression:</P><P>Avg(Sales)</P><P>What I want it changed to is that it will Average the Sales field if the flag is equal to 1</P><P>Avg(Sales) where Flag =1</P><P></P><P>Thanks</P></BODY></HTML> Tue, 22 Jun 2010 23:40:36 GMT https://community.qlik.com/t5/QlikView/Help-with-Average-condition/m-p/198081#M57507 ivandrago 2010-06-22T23:40:36Z Help with Average condition https://community.qlik.com/t5/QlikView/Help-with-Average-condition/m-p/198082#M57508 <HTML><HEAD></HEAD><BODY><P>avg({&lt;Flag={1}&gt;} Sales)</P></BODY></HTML> Wed, 23 Jun 2010 01:03:26 GMT https://community.qlik.com/t5/QlikView/Help-with-Average-condition/m-p/198082#M57508 johnw 2010-06-23T01:03:26Z