topic differences between the average in QlikView https://community.qlik.com/t5/QlikView/differences-between-the-average/m-p/1372747#M830305 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>Will like to ask a question. Let say I have the data below.</P><P></P><P>I will like to find out the differences between the average salary of Male and Female.&nbsp; </P><P></P><P>How should I enter into the expression for the chart?</P><P></P><TABLE width="157"><TBODY><TR><TD class="xl63" height="20" width="64">Gender</TD><TD class="xl63" width="93">Salary</TD></TR><TR><TD class="xl64" height="20">Male </TD><TD align="right" class="xl64">400</TD></TR><TR><TD class="xl64" height="20">Male </TD><TD align="right" class="xl64">1200</TD></TR><TR><TD class="xl64" height="20">Female</TD><TD align="right" class="xl64">500</TD></TR><TR><TD class="xl64" height="20">Male </TD><TD align="right" class="xl64">700</TD></TR><TR><TD class="xl64" height="20">Female</TD><TD align="right" class="xl64">400</TD></TR><TR><TD class="xl64" height="20">Female</TD><TD align="right" class="xl64">300</TD></TR><TR><TD class="xl64" height="20">Male </TD><TD align="right" class="xl64">400</TD></TR><TR><TD class="xl64" height="20">Female</TD><TD align="right" class="xl64">300</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z differences between the average https://community.qlik.com/t5/QlikView/differences-between-the-average/m-p/1372747#M830305 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>Will like to ask a question. Let say I have the data below.</P><P></P><P>I will like to find out the differences between the average salary of Male and Female.&nbsp; </P><P></P><P>How should I enter into the expression for the chart?</P><P></P><TABLE width="157"><TBODY><TR><TD class="xl63" height="20" width="64">Gender</TD><TD class="xl63" width="93">Salary</TD></TR><TR><TD class="xl64" height="20">Male </TD><TD align="right" class="xl64">400</TD></TR><TR><TD class="xl64" height="20">Male </TD><TD align="right" class="xl64">1200</TD></TR><TR><TD class="xl64" height="20">Female</TD><TD align="right" class="xl64">500</TD></TR><TR><TD class="xl64" height="20">Male </TD><TD align="right" class="xl64">700</TD></TR><TR><TD class="xl64" height="20">Female</TD><TD align="right" class="xl64">400</TD></TR><TR><TD class="xl64" height="20">Female</TD><TD align="right" class="xl64">300</TD></TR><TR><TD class="xl64" height="20">Male </TD><TD align="right" class="xl64">400</TD></TR><TR><TD class="xl64" height="20">Female</TD><TD align="right" class="xl64">300</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/differences-between-the-average/m-p/1372747#M830305 2020-11-25T16:16:04Z Re: differences between the average https://community.qlik.com/t5/QlikView/differences-between-the-average/m-p/1372748#M830306 <HTML><HEAD></HEAD><BODY><P>May be this in straight table or chart</P><P>Dimension as Gender</P><P>Expression Avg(Salary) </P><P>or</P><P>Avg({&lt;Gender = {Male}&gt;}Salary)-Avg({&lt;Gender = {Female}&gt;} Salary)</P></BODY></HTML> Wed, 28 Jun 2017 15:24:52 GMT https://community.qlik.com/t5/QlikView/differences-between-the-average/m-p/1372748#M830306 Anil_Babu_Samineni 2017-06-28T15:24:52Z