topic Re: Trending year on year (Jun 2016 - Jul 2017) in QlikView https://community.qlik.com/t5/QlikView/Trending-year-on-year-Jun-2016-Jul-2017/m-p/63200#M10562 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>try this :</P><P>in dimension :&nbsp; year + floor((month -1)/6)</P><P></P><P>you get : 2016 from 201507 to 201606</P><P></P><P>regards,</P></BODY></HTML> Mon, 21 May 2018 08:57:45 GMT ogautier62 2018-05-21T08:57:45Z Trending year on year (Jun 2016 - Jul 2017) https://community.qlik.com/t5/QlikView/Trending-year-on-year-Jun-2016-Jul-2017/m-p/63199#M10561 <HTML><HEAD></HEAD><BODY><P>Good day,</P><P></P><P>I've got a list of data entries together with their respective dates. How can I do year on year comparison on a chart for years that must range between Jun - Jul each year?</P><P></P><P>Sample data attached.</P><P></P><P>This is a snipshot of what the graph should look like:</P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/202936_Capture.JPG" style="height: auto;" /></P></BODY></HTML> Mon, 21 May 2018 08:47:15 GMT https://community.qlik.com/t5/QlikView/Trending-year-on-year-Jun-2016-Jul-2017/m-p/63199#M10561 ranibosch 2018-05-21T08:47:15Z Re: Trending year on year (Jun 2016 - Jul 2017) https://community.qlik.com/t5/QlikView/Trending-year-on-year-Jun-2016-Jul-2017/m-p/63200#M10562 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>try this :</P><P>in dimension :&nbsp; year + floor((month -1)/6)</P><P></P><P>you get : 2016 from 201507 to 201606</P><P></P><P>regards,</P></BODY></HTML> Mon, 21 May 2018 08:57:45 GMT https://community.qlik.com/t5/QlikView/Trending-year-on-year-Jun-2016-Jul-2017/m-p/63200#M10562 ogautier62 2018-05-21T08:57:45Z