topic Variance Calculation in QlikView https://community.qlik.com/t5/QlikView/Variance-Calculation/m-p/204145#M61176 <HTML><HEAD></HEAD><BODY><P></P><P>Hi</P><P>I am trying to caluate the variance between the quarters in a year, I have used the expression below</P><BR /><BR /> <P>=(avg( {$&lt; Quarter = { 'Q1' } &gt;}[Total Average]) - avg( {$&lt; Quarter = { 'Q2' } &gt;}[Total Average])) / avg( {$&lt; Quarter = { 'Q2' } &gt;}[Total Average])</P><P>but i need to include this conditoin ({$&lt;[Directorate]={'Surgery'}&gt;})</P><P></P><P></P><BR /><BR /> <P></P><P></P><BR /><BR /> <P></P><P></P><P>please help</P><BR /><BR /> <P></P><P></P><BR /><BR /> <P></P><P></P><BR /><BR /> <P></P></BODY></HTML> Mon, 29 Nov 2010 11:20:32 GMT 2010-11-29T11:20:32Z Variance Calculation https://community.qlik.com/t5/QlikView/Variance-Calculation/m-p/204145#M61176 <HTML><HEAD></HEAD><BODY><P></P><P>Hi</P><P>I am trying to caluate the variance between the quarters in a year, I have used the expression below</P><BR /><BR /> <P>=(avg( {$&lt; Quarter = { 'Q1' } &gt;}[Total Average]) - avg( {$&lt; Quarter = { 'Q2' } &gt;}[Total Average])) / avg( {$&lt; Quarter = { 'Q2' } &gt;}[Total Average])</P><P>but i need to include this conditoin ({$&lt;[Directorate]={'Surgery'}&gt;})</P><P></P><P></P><BR /><BR /> <P></P><P></P><BR /><BR /> <P></P><P></P><P>please help</P><BR /><BR /> <P></P><P></P><BR /><BR /> <P></P><P></P><BR /><BR /> <P></P></BODY></HTML> Mon, 29 Nov 2010 11:20:32 GMT https://community.qlik.com/t5/QlikView/Variance-Calculation/m-p/204145#M61176 2010-11-29T11:20:32Z