0 Replies Latest reply: Dec 26, 2012 11:15 PM by Managing Director. Syfur Rahaman RSS

    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