4 Replies Latest reply: May 2, 2014 2:16 PM by Nathan Torres RSS

    Compare a period of months against last year??

      Hello everybody!

       

      I'm a new user from Qlikview and I'm stucked with a couple of expressions.

       

      I'm trying to compare same two periods of months; the first is from current year and the second is the previous year.

       

      My first expression is this one:

       

      Sum ( { $ < EstatusCredito = { 'Activo' , 'Cerrada' } , FC_Year = { $(=Max(FC_Year)) } > } Capital )

       

      This actually works properly.

       

      The second one is this one:

       

      Sum ( { $ < EstatusCredito = { 'Activo' , 'Cerrada' } , FC_Year = { $(=Max(FC_Year)-1) } , FC_Month = { $(=Month(Max(FC_MonthYear))) } >  } Capital )

       

      Second one is my headache! Because it always returns only the current month, from last year. What I want is a sum from January (previous year) to the curent month (previous year)

       

      Could anyone help, please?

       

      Thanks!

       

      Nathan T.