9 Replies Latest reply: Apr 3, 2013 6:06 AM by vikas mahajan RSS

    Like Wise comparision between current month month and last year month

    vikas mahajan

      Dear All

       

      Please find attached qlikview – view showing details of current year month and last year month like wise comparision

      As follows

       

      Financial Year  2013

      Financial Year  2012

      30 March 2013 – working day

      Working Day

      31 th  March is a SUNDAY holiday hence there is  no transcation taken place in this day.

      Working Day

       

      When we view this report  for march 2013  it is showing data of last year upto 30-March only , But therewas one day sale recored at 31/12/2012 date  Hence growth calculation is going wrong  , Please refer screen short column no 2 is showing 7.6 lacs less sale.

       

      Please find following are the expression for column no 2

       

      (SUM({$<FinancialYear=,Quarter=,MonthName=,FiscalYear={$(=max(FiscalYear)-1)},

      [Posting Date]={">=$(=YearStart(max([Posting Date]),-1,4))<=$(=addmonths(max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]),-12))"}>}[Gross Sales Amount])

      -

      SUM({$<FinancialYear=,Quarter=,MonthName=,FiscalYear={$(=max(FiscalYear)-1)},

      [Posting Date]={">=$(=YearStart(max([Posting Date]),-1,4))<=$(=addmonths(max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]),-12))"}>}[Sales Return Amount])

      )/100000

       

      Requirement : -

      ·         If user select March Month Full month completed data should display.

      ·         If  Today is  2-April-2013   Sales Current Year  Vs   2-April-2012  sales data should display in last year

       

       

      Kindly advise how to achive the same in said expression.