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: 
kev6brown
Partner - Creator
Partner - Creator

Previous Year

I need a calculation to pull through previous year, I have - 

sum({<Financial_Month={'<= $(=Financial_Month)'},[inc_report_group_3]={'Elective'}, [Calendar Month], Financial_Year = {'=$(=only([Financial_Year]) -)'}>} inc_priceactual) / 1000)
 
Which gives me current year and I assumed adding in -1 to the Financial_Year would pull through last year but it doesn't. What have i done wrong?
 
Thanks
1 Reply
jonas_rezende
Specialist
Specialist

Hi, @kev6brown .

What result does it return?


[]s,
Jonas Rezende.