This content has been marked as final. Show 2 replies
I'm very new with qlikview desktop personal, and keep trying to figure it out the conversion between RDBMS sql syntax to qlikview expression.
'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.