YoY comparison

[#1]

Hi,

I am trying to do a YoY calculation in Qlikview and the required format is to calculate last two columns.

Basically I would like to compared FY2014/Q3 vs. FY2013/Q3, FY2014/Q2 vs. FY2013/Q2 etc.

Quarter	Mortgage	Credit Card	Mortgage	Credit Card
FY2011/Q3	840,320,615	7,392,375
FY2011/Q4	1,099,131,920	8,661,868
FY2012/Q1	1,400,465,653	10,442,134
FY2012/Q2	1,130,945,854	8,856,744
FY2012/Q3	968,496,741	8,057,951	15%	9%
FY2012/Q4	1,100,568,000	10,166,358	0%	17%
FY2013/Q1	1,013,797,457	11,028,765	-28%	6%
FY2013/Q2	1,058,112,416	10,103,552	-6%	14%
FY2013/Q3	936,139,736	8,344,205	-3%	4%
FY2013/Q4	1,050,458,075	9,430,980	-5%	-7%
FY2014/Q1	971,799,267	9,609,576	-4%	-13%
FY2014/Q2	1,009,652,255	9,005,168	-5%	-11%
FY2014/Q3	64,529,627	585,683	-93%	-93%

Thank you.

[arthur_dom]

Create on script a field like this
year(datefield) -1  as Year_1

and use it on set analysis like

sum( Mortgage) / sum( {<Year ={"Year_1"}>} Mortgage)