topic compare dates (M/D) from different years in QlikView https://community.qlik.com/t5/QlikView/compare-dates-M-D-from-different-years/m-p/376301#M572062 <HTML><HEAD></HEAD><BODY><P>I have sales figures associated with different dates (M/D/YYYY). I'd like to get them graphed in a line graph, each year being it's own line.</P><P></P><P>I've broken imported the dates in the script to "day" (e.g, 1, 2 ..., 31), "month" (Jan - Apr), and "year" (2008 - 2012) as well as the full "date" (i.e., M/D/YYYY). I'm comfortable aggregating dates into separate lines by using set analysis to pluck out one year per line, but I'm not sure to establish a shared x-axis.</P></BODY></HTML> Wed, 08 Aug 2012 17:41:14 GMT 2012-08-08T17:41:14Z compare dates (M/D) from different years https://community.qlik.com/t5/QlikView/compare-dates-M-D-from-different-years/m-p/376301#M572062 <HTML><HEAD></HEAD><BODY><P>I have sales figures associated with different dates (M/D/YYYY). I'd like to get them graphed in a line graph, each year being it's own line.</P><P></P><P>I've broken imported the dates in the script to "day" (e.g, 1, 2 ..., 31), "month" (Jan - Apr), and "year" (2008 - 2012) as well as the full "date" (i.e., M/D/YYYY). I'm comfortable aggregating dates into separate lines by using set analysis to pluck out one year per line, but I'm not sure to establish a shared x-axis.</P></BODY></HTML> Wed, 08 Aug 2012 17:41:14 GMT https://community.qlik.com/t5/QlikView/compare-dates-M-D-from-different-years/m-p/376301#M572062 2012-08-08T17:41:14Z Re: compare dates (M/D) from different years https://community.qlik.com/t5/QlikView/compare-dates-M-D-from-different-years/m-p/376302#M572065 <HTML><HEAD></HEAD><BODY><P>Apprently posting the question is further impetus to <EM>not stop thinking about it</EM>.</P><P></P><P></P><P>I used a calculated dimension and concatenated the month and day:</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13444586442056006" jivemacro_uid="_13444586442056006"><P>=Month(Date) &amp; Day(Date)</P></PRE><P></P><P></P><P>Less readable for my users (but still solving my original issue) would be to use the calculated dimension:</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13444587053552301" jivemacro_uid="_13444587053552301"><P>=DayNumberOfYear(Date)</P></PRE></BODY></HTML> Wed, 08 Aug 2012 20:46:04 GMT https://community.qlik.com/t5/QlikView/compare-dates-M-D-from-different-years/m-p/376302#M572065 2012-08-08T20:46:04Z