topic How to easily create YoY Comparison in Chart in QlikView https://community.qlik.com/t5/QlikView/How-to-easily-create-YoY-Comparison-in-Chart/m-p/752871#M534408 <HTML><HEAD></HEAD><BODY><P>I have some data where I would like to have a year over year comparison. My data has a Fiscal Year Quarter field with values of 2014-Q1 to 2015-Q4. Is there a simple way using expressions to create a YoY comparison chart like the image below?</P><P><IMG alt="QV-chart.PNG" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/80052_QV-chart.PNG" style="height: auto;" /></P><P></P><P>Thanks in advance!</P></BODY></HTML> Thu, 05 Mar 2015 19:39:40 GMT 2015-03-05T19:39:40Z How to easily create YoY Comparison in Chart https://community.qlik.com/t5/QlikView/How-to-easily-create-YoY-Comparison-in-Chart/m-p/752871#M534408 <HTML><HEAD></HEAD><BODY><P>I have some data where I would like to have a year over year comparison. My data has a Fiscal Year Quarter field with values of 2014-Q1 to 2015-Q4. Is there a simple way using expressions to create a YoY comparison chart like the image below?</P><P><IMG alt="QV-chart.PNG" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/80052_QV-chart.PNG" style="height: auto;" /></P><P></P><P>Thanks in advance!</P></BODY></HTML> Thu, 05 Mar 2015 19:39:40 GMT https://community.qlik.com/t5/QlikView/How-to-easily-create-YoY-Comparison-in-Chart/m-p/752871#M534408 2015-03-05T19:39:40Z Re: How to easily create YoY Comparison in Chart https://community.qlik.com/t5/QlikView/How-to-easily-create-YoY-Comparison-in-Chart/m-p/752872#M534409 <HTML><HEAD></HEAD><BODY><P>using 2 calculated dimensions (red rectangle)</P><P>and 1 expression (green)</P><P><IMG alt="1.jpg" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/80054_1.jpg" style="height: 268px; width: 620px;" /></P></BODY></HTML> Thu, 05 Mar 2015 19:48:09 GMT https://community.qlik.com/t5/QlikView/How-to-easily-create-YoY-Comparison-in-Chart/m-p/752872#M534409 maxgro 2015-03-05T19:48:09Z Re: How to easily create YoY Comparison in Chart https://community.qlik.com/t5/QlikView/How-to-easily-create-YoY-Comparison-in-Chart/m-p/752873#M534410 <HTML><HEAD></HEAD><BODY><P>Perfect! This is exactly what I need. Thanks Massimo!</P></BODY></HTML> Thu, 05 Mar 2015 21:19:10 GMT https://community.qlik.com/t5/QlikView/How-to-easily-create-YoY-Comparison-in-Chart/m-p/752873#M534410 2015-03-05T21:19:10Z