Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

compare dates (M/D) from different years

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.

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.

1 Solution

Accepted Solutions
Not applicable
Author

Apprently posting the question is further impetus to not stop thinking about it.

I used a calculated dimension and concatenated the month and day:

=Month(Date) & Day(Date)

Less readable for my users (but still solving my original issue) would be to use the calculated dimension:

=DayNumberOfYear(Date)

View solution in original post

1 Reply
Not applicable
Author

Apprently posting the question is further impetus to not stop thinking about it.

I used a calculated dimension and concatenated the month and day:

=Month(Date) & Day(Date)

Less readable for my users (but still solving my original issue) would be to use the calculated dimension:

=DayNumberOfYear(Date)