topic expression for % variance in Qlik Learning Discussions https://community.qlik.com/t5/Qlik-Learning-Discussions/expression-for-variance/m-p/756057#M1476 <HTML><HEAD></HEAD><BODY><P>my target is&nbsp; to make a comparison %not&nbsp; by line but by column.</P><P>as you see in the attached excel file , i have some totals in line 17 and i want to do the % comparisson with the numbers above them.</P><P>doing that in excel file is easy but i dont know the expression yet for the qlick.</P></BODY></HTML> Mon, 03 Nov 2014 13:23:35 GMT 2014-11-03T13:23:35Z expression for % variance https://community.qlik.com/t5/Qlik-Learning-Discussions/expression-for-variance/m-p/756057#M1476 <HTML><HEAD></HEAD><BODY><P>my target is&nbsp; to make a comparison %not&nbsp; by line but by column.</P><P>as you see in the attached excel file , i have some totals in line 17 and i want to do the % comparisson with the numbers above them.</P><P>doing that in excel file is easy but i dont know the expression yet for the qlick.</P></BODY></HTML> Mon, 03 Nov 2014 13:23:35 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/expression-for-variance/m-p/756057#M1476 2014-11-03T13:23:35Z Re: expression for % variance https://community.qlik.com/t5/Qlik-Learning-Discussions/expression-for-variance/m-p/756058#M1477 <HTML><HEAD></HEAD><BODY><P>Hi Thanasis</P><P></P><P>I think the expression you are looking for is</P><P></P><P>sum(item1)/sum(TOTAL item1)</P><P></P><P>Don't forget to click on the Relative check box on the Expressions tab.</P><P></P><P>Cheers</P><P>Agis</P></BODY></HTML> Mon, 03 Nov 2014 13:36:21 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/expression-for-variance/m-p/756058#M1477 Agis-Kalogiannis 2014-11-03T13:36:21Z