https://community.qlik.com/t5/App-Development/Year-over-Year-comparison-with-two-lines/m-p/2135489#M92284 <P>I have a line chart with a measure showing cumulative Sales and data period covering 2022 and 2023. Wish to show this as a year over year comparison. To this end, I use the function&nbsp;<SPAN>DayNumberOfYear(mydate) and Year(mydate) as dimensions. This gives me the Year-lines on on top of each other and comparable, which is what I want.</SPAN></P> <P><SPAN>However, the x-axis for DayNumberofYear is uninformative, in the sense that it does not immediately tell you the month or date of the year you are looking at (see attached PNG). </SPAN></P> <P><SPAN>How can I convert day numbers of year to regular dates so that I get a time-series which simply lists&nbsp;</SPAN><SPAN><STRONG>1.1 to 31.12</STRONG> (without specifying a year), rather than listing the days as numbers</SPAN></P> Tue, 07 Nov 2023 15:36:16 GMT retretrt 2023-11-07T15:36:16Z https://community.qlik.com/t5/App-Development/Year-over-Year-comparison-with-two-lines/m-p/2135489#M92284 <P>I have a line chart with a measure showing cumulative Sales and data period covering 2022 and 2023. Wish to show this as a year over year comparison. To this end, I use the function&nbsp;<SPAN>DayNumberOfYear(mydate) and Year(mydate) as dimensions. This gives me the Year-lines on on top of each other and comparable, which is what I want.</SPAN></P> <P><SPAN>However, the x-axis for DayNumberofYear is uninformative, in the sense that it does not immediately tell you the month or date of the year you are looking at (see attached PNG). </SPAN></P> <P><SPAN>How can I convert day numbers of year to regular dates so that I get a time-series which simply lists&nbsp;</SPAN><SPAN><STRONG>1.1 to 31.12</STRONG> (without specifying a year), rather than listing the days as numbers</SPAN></P> Tue, 07 Nov 2023 15:36:16 GMT https://community.qlik.com/t5/App-Development/Year-over-Year-comparison-with-two-lines/m-p/2135489#M92284 retretrt 2023-11-07T15:36:16Z https://community.qlik.com/t5/App-Development/Year-over-Year-comparison-with-two-lines/m-p/2135510#M92285 <P>You could maybe try to replace&nbsp;<SPAN>DayNumberOfYear(mydate) with:<BR /><FONT face="courier new,courier">=dual(Date(YearStart(Today())+DayNumberOfYear(mydate)-1,'DD-MMM'),DayNumberOfYear(mydate))</FONT><BR /></SPAN></P> Tue, 07 Nov 2023 16:38:47 GMT https://community.qlik.com/t5/App-Development/Year-over-Year-comparison-with-two-lines/m-p/2135510#M92285 vincent_ardiet_ 2023-11-07T16:38:47Z