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

Line Chart displaying two seperate time periods

I am trying to create a line chart that displays sales data from a year that I select and would like it to also show me the same data from the previous year, and have it all broken down by months. Would love it if someone could help me on this, thanks in advance.

1 Reply
Not applicable
Author

You will need two expressions ... (samples)


sum( {$<Year = {$(=Only(Year))}>} Sales )
sum( {$<Year = {$(=Only(Year)-1)}>} Sales )


The first calculates the Sales for the selected Year and the second the same for the year before that.

You use the Month as a dimension.