Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Sgiri
Contributor II
Contributor II

Show last year data of Current month

Hello Everyone, 

   In a table I wanted to show last year January Data when the current month is feb. When it is march then I have to show last year (2019) January and February sales amount and when it is April then the table should update for January, February and March 2019 data. Likewise for all other months.

 

  I have a field called [Eff_Date.autoCalendar.Date] which has data like 1/1/2018 till 02/28/2020.

 

Thanks.

2 Replies
dplr-rn
Partner - Master III
Partner - Master III

share an example of the table you want. it not completely clear.

but on a high level you could use set analysis. assuming only measure you want is last years data use a measure like below

e.g. Sum({<Date={">= $( YearStart(addyears(today(),-1)) )<=$(MonthEnd(addmonths(today(),-13)) )"}>}Sales)

Sgiri
Contributor II
Contributor II
Author

Hello , 

   I want to show my table like the below I got sum(sales) for 2020 as expected but I could not achieve the sales of 2019. 

 

Any solution to solve my issue.

Date (MM/DD)

Sales of 2020

Sales of 2019

02/2020

Jan 2020 Sales

Jan 2019 Sales

03/2020

Jan, Feb 2020 Sales

Jan, Feb 2019 Sales

04/2020

Jan, Feb, March 2020 Sales

Jan, Feb, March 2019 Sales