Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Previous year calculation

Hi, I'm trying to set a Pivot table in one sheet that includes Actual period and Last year period for the same dimension in order to calculate a growing percentage. However I can't get previous year information (See attached file) only for the dimension that have the actual date.

I have customer in Rows, period in columns... So when I have a column saying, (e.g.) 1/1/17, the previous year information doesn't pop up.. Just the actual period data.

Thanks in advance for your support.

2 Replies
sunny_talwar

You might need to use The As-Of Table or look at Missing Manual - Above() and Below()

jomar_ebonite
Partner - Contributor III
Partner - Contributor III

Hi Adrian,

You can't get the previous data based on the specific date.

Instead of using actual Date as selection or column, you can use Day.

To get Day of date:

Day(Period) as Day

Thanks,

Jomar