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: 
Not applicable

Current year and previous year fiscal year calculation(July-June)

Hi everyone,

I am new in Qlikview.I need your expart solution.Please help me .I am getting problem with prevoius fiscal year calculation.

When I select year -2010 and Month - Feb

then current year data is 2010 july to 2011 feb(getting right data) and

prevoius year data is 2009 july to 2010 feb(getting data from 2009 july to 2010 june(its worng data)).

My current year expression is -

=num(sum({$<Year1 = {$(=max(Year1))}, MonthName = {"<=$(=max({<Year1={$(=max(Year1))}>} MonthName))"}>} if(PARTICODE=500 or PARTICODE=600 or PARTICODE=610 or PARTICODE=640 or PARTICODE=645 or PARTICODE=650 or PARTICODE=655, ActualAmount2)))

and its working fine.

But previous year calculation expression is -

=num(sum({$<Year1={$(=Year(Max(Year1))-1)}, MonthName = {"<=$(=max({<Year1={$(=max(Year1))}>} MonthName))"}>}  if(PARTICODE=500 or PARTICODE=600 or PARTICODE=610 or PARTICODE=640 or PARTICODE=645 or PARTICODE=650 or PARTICODE=655, ActualAmount2)))

Thanks

0 Replies