Discussion board where members can get started with QlikView.
I am using a straight table that is setup to show Sales Data by customer. I want to do a comparison to last year. So if 2012 is choosen as a filter, I want a column to show sales in 2011. How can I get it to know to subtract a year in that column.
Go to Solution.
Use set analysis.
you can do it by creating a variable for maxyear.
kindly find the attachement of sample qvw
i hope it will help you.
I have a trial version of qlikview so I cannot open your document, any way you can send over the script in an email?
Lance H. James, CPA
Director of Finance
The Aspen Brands Company
Kate Aspen · Baby Aspen
678.282.0053 x 777
LOAD * Inline
First create a variable vMaxYear=Max(Year)
create a stright table with following Expressions:.
for current Year
for prevoius Year
diffrence beween the above two year
Thanks it worked.