Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Matt_Jester
Contributor II
Contributor II

Best Method to Include Prior Year

In my extraction layer, I have a large data set (sales by Site, SKU & day). In most applications that I will be creating, I will need to show year over year comparisons. In apps where I will need to have sales by day, which are few and far between, I know that I can do a set analysis to create variables that show sales for the selected time period and the same time period last year. I expect that I could do this for data aggregated by week and month as well.

I have access to the fiscal calendar which has columns showing the date and the match date for the prior year, as shown below:  

DATEDATE_PY
12/31/20171/1/2017
1/1/20181/2/2017
1/2/20181/3/2017
1/3/20181/4/2017
1/4/20181/5/2017
1/5/20181/6/2017
1/6/20181/7/2017

From a system/app performance perspective, would it be better to use the set analysis or to add the sales from the prior year as another column in the transformation layer?

1 Reply
bill_markham
Champion III
Champion III

I would go for your set analysis option