Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
pabloperezgarcia
Contributor II
Contributor II

date range picker: get last year from actual year dates

Hello,

I have this chart and I am comparing periods of time... I mean 25/07/2019 to 01/08/2019 with 25/07/2019 to 01/08/2019: 

datepicker.PNG

 

How can I do that inmy expression for this chart, because Itis not working for the last year:

I have this for last year but it's not working: 

Sum({<Date={AddYears(Date,-1)}>}Sales) 

chart.PNG

 

Thanks!!

 

 

Labels (3)
0 Replies