topic Re: How to create an expression for variance in QlikView https://community.qlik.com/t5/QlikView/How-to-create-an-expression-for-variance/m-p/448965#M167520 <HTML><HEAD></HEAD><BODY><P>You can use the following if ur quarters are already defined...</P><P></P><P></P><P>(Sum({&lt;Year={"=$(max(Year))"},Quarter={"=$(max(Quarter))"}&gt;}Sales) - Sum({&lt;Year={"=$(max(Year))-1"},Quarter={"=$(max(Quarter))"}&gt;}Sales))/ Sum({&lt;Year={"=$(max(Year))-1"},Quarter={"=$(max(Quarter))"}&gt;}Sales))</P><P></P><P>Hope to Help!!! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 27 Sep 2012 12:44:30 GMT rajni_batra 2012-09-27T12:44:30Z How to create an expression for variance https://community.qlik.com/t5/QlikView/How-to-create-an-expression-for-variance/m-p/448964#M167519 <HTML><HEAD></HEAD><BODY><P>My company relies on variance to see the year over year and quarter over quarter picture. How could I create an expression that would solve this? This is the equation we currently use in excel: (Q3 2012-Q3 2011)/Q3 2011. For exemple, (cell B14-cellcell B10)/cell B10. Has anyone had this issue before and found a solution?</P></BODY></HTML> Thu, 27 Sep 2012 12:26:11 GMT https://community.qlik.com/t5/QlikView/How-to-create-an-expression-for-variance/m-p/448964#M167519 2012-09-27T12:26:11Z Re: How to create an expression for variance https://community.qlik.com/t5/QlikView/How-to-create-an-expression-for-variance/m-p/448965#M167520 <HTML><HEAD></HEAD><BODY><P>You can use the following if ur quarters are already defined...</P><P></P><P></P><P>(Sum({&lt;Year={"=$(max(Year))"},Quarter={"=$(max(Quarter))"}&gt;}Sales) - Sum({&lt;Year={"=$(max(Year))-1"},Quarter={"=$(max(Quarter))"}&gt;}Sales))/ Sum({&lt;Year={"=$(max(Year))-1"},Quarter={"=$(max(Quarter))"}&gt;}Sales))</P><P></P><P>Hope to Help!!! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 27 Sep 2012 12:44:30 GMT https://community.qlik.com/t5/QlikView/How-to-create-an-expression-for-variance/m-p/448965#M167520 rajni_batra 2012-09-27T12:44:30Z Re: How to create an expression for variance https://community.qlik.com/t5/QlikView/How-to-create-an-expression-for-variance/m-p/448966#M167521 <HTML><HEAD></HEAD><BODY><P>Did you get the solution for this? if yes how did you solve it? I am also having the same problem please help me on this.</P><P>Regards</P><P>John</P></BODY></HTML> Mon, 19 Oct 2015 06:37:58 GMT https://community.qlik.com/t5/QlikView/How-to-create-an-expression-for-variance/m-p/448966#M167521 2015-10-19T06:37:58Z