Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Year Over Year Comparison of Date Range


I have a table with sales data as well as the order dates and I need to have a Year over Year comparison of the same current date period last year...


Since today is 1/24/18, then I need to take the sum of sales for 2018 (1/1/18 to 1/24/2018) - the sum of sales from (1/1/17 to 1/24/17)

I prefer to use this calculation in a KPI but if it needs to be in a straight table or pivot table that is acceptable.

I know I can get the first part but not the same date range a year ago.  Please help if possible!

1 Reply
MVP & Luminary
MVP & Luminary

Re: Year Over Year Comparison of Date Range


Check below link. Hope that helps.

Set Analysis for certain Point in Time


Kaushik Solanki

If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".