topic Re: Calculating Yearwise Sales in QlikView https://community.qlik.com/t5/QlikView/Calculating-Yearwise-Sales/m-p/483749#M180751 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Please find the attached which I using Before() function to calculate different of the year.</P><P></P><P></P><P></P><P><BR /> </P></BODY></HTML> Mon, 25 Nov 2013 07:22:13 GMT Anonymous 2013-11-25T07:22:13Z Calculating Yearwise Sales https://community.qlik.com/t5/QlikView/Calculating-Yearwise-Sales/m-p/483745#M180747 <HTML><HEAD></HEAD><BODY><P>Dear Folks,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I have attached the excel sheet what i want to calculate in pivot table. can u please suggest me the expression ASAP.</P></BODY></HTML> Mon, 25 Nov 2013 06:50:24 GMT https://community.qlik.com/t5/QlikView/Calculating-Yearwise-Sales/m-p/483745#M180747 2013-11-25T06:50:24Z Re: Calculating Yearwise Sales https://community.qlik.com/t5/QlikView/Calculating-Yearwise-Sales/m-p/483746#M180748 <HTML><HEAD></HEAD><BODY><P>Unable to see the doc data .</P><P>Can you post a sample to me or explain in details </P></BODY></HTML> Mon, 25 Nov 2013 06:56:35 GMT https://community.qlik.com/t5/QlikView/Calculating-Yearwise-Sales/m-p/483746#M180748 sujeetsingh 2013-11-25T06:56:35Z Re: Calculating Yearwise Sales https://community.qlik.com/t5/QlikView/Calculating-Yearwise-Sales/m-p/483747#M180749 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>For that, you want to create separate expression.</P><P></P><P>Like </P><P>2010 =Sum({&lt;Year = {2010}&gt;}Sales)</P><P>2011 =Sum({&lt;Year = {2011}&gt;}Sales)</P><P>2011-2010 =Column(2) - Column(1)</P></BODY></HTML> Mon, 25 Nov 2013 07:03:03 GMT https://community.qlik.com/t5/QlikView/Calculating-Yearwise-Sales/m-p/483747#M180749 MayilVahanan 2013-11-25T07:03:03Z Re: Calculating Yearwise Sales https://community.qlik.com/t5/QlikView/Calculating-Yearwise-Sales/m-p/483748#M180750 <HTML><HEAD></HEAD><BODY><P>Dear Folks,</P><P>This is the data i need</P><TABLE border="0" cellpadding="0" cellspacing="0" width="731"><TBODY><TR><TD class="xl65" height="17" width="98"> </TD><TD class="xl66" style="border-left: medium none;" width="15"> </TD><TD class="xl67" style="border-left: medium none;" width="98"> </TD><TD class="xl65" style="border-left: medium none;" width="98"> </TD><TD class="xl65" style="border-left: medium none;" width="98"> </TD><TD class="xl67" style="border-left: medium none;" width="98"> </TD><TD class="xl67" style="border-left: medium none;" width="98"> </TD><TD class="xl68" style="border-left: medium none;" width="64"> </TD><TD class="xl68" style="border-left: medium none;" width="64"> </TD></TR><TR><TD class="xl65" height="17" style="border-top: medium none;">Year</TD><TD class="xl66" style="border-top: medium none; border-left: medium none;"> </TD><TD align="right" class="xl67" style="border-top: medium none; border-left: medium none;">2,010</TD><TD align="right" class="xl69" style="border-top: medium none; border-left: medium none;">2011</TD><TD class="xl69" style="border-top: medium none; border-left: medium none;">Diff(2011-2010)</TD><TD align="right" class="xl69" style="border-top: medium none; border-left: medium none;">2012</TD><TD class="xl69" style="border-top: medium none; border-left: medium none;">Diff(2012-2011)</TD><TD align="right" class="xl69" style="border-top: medium none; border-left: medium none;">2013</TD><TD class="xl69" style="border-top: medium none; border-left: medium none;">Diff(2013-2012)</TD></TR><TR><TD class="xl68" height="17" style="border-top: medium none;">Item</TD><TD class="xl68" style="border-top: medium none; border-left: medium none;"> </TD><TD class="xl68" style="border-top: medium none; border-left: medium none;"> </TD><TD class="xl68" style="border-top: medium none; border-left: medium none;"> </TD><TD class="xl68" style="border-top: medium none; border-left: medium none;"> </TD><TD class="xl68" style="border-top: medium none; border-left: medium none;"> </TD><TD class="xl68" style="border-top: medium none; border-left: medium none;"> </TD><TD class="xl68" style="border-top: medium none; border-left: medium none;"> </TD><TD class="xl68" style="border-top: medium none; border-left: medium none;"> </TD></TR><TR><TD class="xl65" height="17" style="border-top: medium none;">AAA</TD><TD class="xl66" style="border-top: medium none; border-left: medium none;"> </TD><TD align="right" class="xl67" style="border-top: medium none; border-left: medium none;">664</TD><TD align="right" class="xl67" style="border-top: medium none; border-left: medium none;">210</TD><TD align="right" class="xl67" style="border-top: medium none; border-left: medium none;">-454</TD><TD align="right" class="xl67" style="border-top: medium none; border-left: medium none;">275</TD><TD align="right" class="xl67" style="border-top: medium none; border-left: medium none;">65</TD><TD align="right" class="xl67" style="border-top: medium none; border-left: medium none;">99</TD><TD align="right" class="xl70" style="border-top: medium none; border-left: medium none;">-176</TD></TR><TR><TD class="xl65" height="17" style="border-top: medium none;">BBB</TD><TD class="xl66" style="border-top: medium none; border-left: medium none;"> </TD><TD align="right" class="xl69" style="border-top: medium none; border-left: medium none;">0</TD><TD align="right" class="xl67" style="border-top: medium none; border-left: medium none;">90</TD><TD align="right" class="xl67" style="border-top: medium none; border-left: medium none;">90</TD><TD align="right" class="xl67" style="border-top: medium none; border-left: medium none;">1,252</TD><TD align="right" class="xl67" style="border-top: medium none; border-left: medium none;">1,162</TD><TD align="right" class="xl67" style="border-top: medium none; border-left: medium none;">607</TD><TD align="right" class="xl70" style="border-top: medium none; border-left: medium none;">-645</TD></TR><TR><TD class="xl65" height="17" style="border-top: medium none;">CCC</TD><TD class="xl66" style="border-top: medium none; border-left: medium none;"> </TD><TD align="right" class="xl67" style="border-top: medium none; border-left: medium none;">-6</TD><TD align="right" class="xl67" style="border-top: medium none; border-left: medium none;">1</TD><TD align="right" class="xl67" style="border-top: medium none; border-left: medium none;">7</TD><TD align="right" class="xl67" style="border-top: medium none; border-left: medium none;">678</TD><TD align="right" class="xl67" style="border-top: medium none; border-left: medium none;">677</TD><TD align="right" class="xl67" style="border-top: medium none; border-left: medium none;">3</TD><TD align="right" class="xl70" style="border-top: medium none; border-left: medium none;">-675</TD></TR><TR><TD class="xl65" height="17" style="border-top: medium none;">DDD</TD><TD class="xl66" style="border-top: medium none; border-left: medium none;"> </TD><TD align="right" class="xl67" style="border-top: medium none; border-left: medium none;">9,210</TD><TD align="right" class="xl67" style="border-top: medium none; border-left: medium none;">30</TD><TD align="right" class="xl67" style="border-top: medium none; border-left: medium none;">-9,180</TD><TD align="right" class="xl67" style="border-top: medium none; border-left: medium none;">14,852</TD><TD align="right" class="xl67" style="border-top: medium none; border-left: medium none;">14,822</TD><TD align="right" class="xl67" style="border-top: medium none; border-left: medium none;">-35</TD><TD align="right" class="xl70" style="border-top: medium none; border-left: medium none;">-14,887</TD></TR></TBODY></TABLE></BODY></HTML> Mon, 25 Nov 2013 07:03:17 GMT https://community.qlik.com/t5/QlikView/Calculating-Yearwise-Sales/m-p/483748#M180750 2013-11-25T07:03:17Z Re: Calculating Yearwise Sales https://community.qlik.com/t5/QlikView/Calculating-Yearwise-Sales/m-p/483749#M180751 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Please find the attached which I using Before() function to calculate different of the year.</P><P></P><P></P><P></P><P><BR /> </P></BODY></HTML> Mon, 25 Nov 2013 07:22:13 GMT https://community.qlik.com/t5/QlikView/Calculating-Yearwise-Sales/m-p/483749#M180751 Anonymous 2013-11-25T07:22:13Z Re: Calculating Yearwise Sales https://community.qlik.com/t5/QlikView/Calculating-Yearwise-Sales/m-p/483750#M180752 <HTML><HEAD></HEAD><BODY><P>Dear Jerry</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Thank u very much. thats what i want..</P><P></P><P></P><P>Regards</P><P>Sakthi.S</P></BODY></HTML> Mon, 25 Nov 2013 07:30:07 GMT https://community.qlik.com/t5/QlikView/Calculating-Yearwise-Sales/m-p/483750#M180752 2013-11-25T07:30:07Z