Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor

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

Re: Year Over Year Comparison of Date Range


Check below link. Hope that helps.

Set Analysis for certain Point in Time


Kaushik Solanki