Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
kev6brown
Partner
Partner

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.