topic Re: YoY comparison in QlikView https://community.qlik.com/t5/QlikView/YoY-comparison/m-p/642447#M1089783 <HTML><HEAD></HEAD><BODY><P>Create on script a field like this <BR />year(datefield) -1&nbsp; as Year_1</P><P></P><P>and use it on set analysis like</P><P></P><P>sum( <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Mortgage</SPAN>) / sum( {&lt;Year ={"Year_1"}&gt;} <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Mortgage</SPAN>) </P></BODY></HTML> Wed, 21 May 2014 19:52:04 GMT arthur_dom 2014-05-21T19:52:04Z YoY comparison https://community.qlik.com/t5/QlikView/YoY-comparison/m-p/642446#M1089782 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>I am trying to do a YoY calculation in Qlikview and the required format is to calculate last two columns.</P><P>Basically I would like to compared FY2014/Q3 vs. FY2013/Q3, FY2014/Q2 vs. FY2013/Q2 etc.</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 495px;"><TBODY><TR><TD class="xl63" height="18" width="172">Quarter</TD><TD class="xl64" style="border-left: none;" width="98">Mortgage</TD><TD class="xl64" style="border-left: none;" width="98">Credit Card</TD><TD class="xl68" style="border-left: none;" width="59"><SPAN style="color: #ff0000;">Mortgage</SPAN></TD><TD class="xl68" style="border-left: none;" width="68"><SPAN style="color: #ff0000;">Credit Card</SPAN></TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">FY2011/Q3</TD><TD align="right" class="xl66" style="border-top: none;">840,320,615</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">7,392,375</TD><TD></TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">FY2011/Q4</TD><TD align="right" class="xl66" style="border-top: none;">1,099,131,920</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">8,661,868</TD><TD></TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">FY2012/Q1</TD><TD align="right" class="xl66" style="border-top: none;">1,400,465,653</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">10,442,134</TD><TD></TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">FY2012/Q2</TD><TD align="right" class="xl66" style="border-top: none;">1,130,945,854</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">8,856,744</TD><TD></TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">FY2012/Q3</TD><TD align="right" class="xl66" style="border-top: none;">968,496,741</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">8,057,951</TD><TD align="right" class="xl67">15%</TD><TD align="right" class="xl67">9%</TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">FY2012/Q4</TD><TD align="right" class="xl66" style="border-top: none;">1,100,568,000</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">10,166,358</TD><TD align="right" class="xl67">0%</TD><TD align="right" class="xl67">17%</TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">FY2013/Q1</TD><TD align="right" class="xl66" style="border-top: none;">1,013,797,457</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">11,028,765</TD><TD align="right" class="xl67">-28%</TD><TD align="right" class="xl67">6%</TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">FY2013/Q2</TD><TD align="right" class="xl66" style="border-top: none;">1,058,112,416</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">10,103,552</TD><TD align="right" class="xl67">-6%</TD><TD align="right" class="xl67">14%</TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">FY2013/Q3</TD><TD align="right" class="xl66" style="border-top: none;">936,139,736</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">8,344,205</TD><TD align="right" class="xl67">-3%</TD><TD align="right" class="xl67">4%</TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">FY2013/Q4</TD><TD align="right" class="xl66" style="border-top: none;">1,050,458,075</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">9,430,980</TD><TD align="right" class="xl67">-5%</TD><TD align="right" class="xl67">-7%</TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">FY2014/Q1</TD><TD align="right" class="xl66" style="border-top: none;">971,799,267</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">9,609,576</TD><TD align="right" class="xl67">-4%</TD><TD align="right" class="xl67">-13%</TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">FY2014/Q2</TD><TD align="right" class="xl66" style="border-top: none;">1,009,652,255</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">9,005,168</TD><TD align="right" class="xl67">-5%</TD><TD align="right" class="xl67">-11%</TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">FY2014/Q3</TD><TD align="right" class="xl66" style="border-top: none;">64,529,627</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">585,683</TD><TD align="right" class="xl67">-93%</TD><TD align="right" class="xl67">-93%</TD></TR></TBODY></TABLE><P></P><P>Thank you.</P></BODY></HTML> Wed, 21 May 2014 19:47:38 GMT https://community.qlik.com/t5/QlikView/YoY-comparison/m-p/642446#M1089782 2014-05-21T19:47:38Z Re: YoY comparison https://community.qlik.com/t5/QlikView/YoY-comparison/m-p/642447#M1089783 <HTML><HEAD></HEAD><BODY><P>Create on script a field like this <BR />year(datefield) -1&nbsp; as Year_1</P><P></P><P>and use it on set analysis like</P><P></P><P>sum( <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Mortgage</SPAN>) / sum( {&lt;Year ={"Year_1"}&gt;} <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Mortgage</SPAN>) </P></BODY></HTML> Wed, 21 May 2014 19:52:04 GMT https://community.qlik.com/t5/QlikView/YoY-comparison/m-p/642447#M1089783 arthur_dom 2014-05-21T19:52:04Z