topic Re: Average Salary in QlikView https://community.qlik.com/t5/QlikView/Average-Salary/m-p/749586#M267423 <HTML><HEAD></HEAD><BODY><P>In a straight table you can have Position as dimension and Avg(Salary) as an expression.</P><P></P><P>Within a text box, if you want a average salary for a particular position, you can do something like this:</P><P></P><P><STRONG>Avg({&lt;Position = {'CEO'}&gt;} Salary)</STRONG></P><P></P><P>HTH</P><P></P><P>Best,</P><P>S</P></BODY></HTML> Thu, 05 Mar 2015 14:31:47 GMT sunny_talwar 2015-03-05T14:31:47Z Average Salary https://community.qlik.com/t5/QlikView/Average-Salary/m-p/749584#M267421 <HTML><HEAD></HEAD><BODY><P>How do I calculate average salary for a particular position?</P></BODY></HTML> Thu, 05 Mar 2015 14:29:11 GMT https://community.qlik.com/t5/QlikView/Average-Salary/m-p/749584#M267421 2015-03-05T14:29:11Z Re: Average Salary https://community.qlik.com/t5/QlikView/Average-Salary/m-p/749585#M267422 <HTML><HEAD></HEAD><BODY><P>avg({&lt; [Position]={ 'POSITION' } &gt;} [Salary])</P></BODY></HTML> Thu, 05 Mar 2015 14:30:31 GMT https://community.qlik.com/t5/QlikView/Average-Salary/m-p/749585#M267422 chrislofthouse 2015-03-05T14:30:31Z Re: Average Salary https://community.qlik.com/t5/QlikView/Average-Salary/m-p/749586#M267423 <HTML><HEAD></HEAD><BODY><P>In a straight table you can have Position as dimension and Avg(Salary) as an expression.</P><P></P><P>Within a text box, if you want a average salary for a particular position, you can do something like this:</P><P></P><P><STRONG>Avg({&lt;Position = {'CEO'}&gt;} Salary)</STRONG></P><P></P><P>HTH</P><P></P><P>Best,</P><P>S</P></BODY></HTML> Thu, 05 Mar 2015 14:31:47 GMT https://community.qlik.com/t5/QlikView/Average-Salary/m-p/749586#M267423 sunny_talwar 2015-03-05T14:31:47Z