2 Replies Latest reply: Sep 2, 2011 10:01 PM by Irman Nator RSS

    Sum total with conditional expression

      Hi All

       

      I'm very new with qlikview desktop personal, and keep trying to figure it out the conversion between RDBMS sql syntax to qlikview expression.

      I

      'm trying to create a selling history within several years 2009, 2010, 2011,

      but with one condition

      - a history selling of 2011, is a sum total sales recorded in 2008,

      - a history selling of 2010, is a sum total sales recorded in 2007,

      - a history selling of 2009, is a sum total sales recorded in 2006.

       

      Any point regarding this will be more helpful on this.

       

      Thank you

       

      Best regards,

      Irman