Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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)