topic Last 8 weeks last year in QlikView

Last 8 weeks last year

sifatnabil — Wed, 13 Jan 2016 09:32:53 GMT

Hi,

I have a line graph showing the last 8 weeks of revenue, using the dimension =date(aggr(if(Rank([Week])<=8,[Week]),[Week]),'D MMM')

How can I show the same last 8 weeks but from last year on a line chart?

Anonymous — Wed, 13 Jan 2016 09:39:33 GMT

Let VLastyear=max(YearField)-1

Take this as Dim =date(aggr(if(Rank([Week])<=8,[Week]),[Week]),'D MMM')

Expression: =sum({<YearField={'=$(=VLastyear'}>} sales)

prma7799 — Wed, 13 Jan 2016 09:40:12 GMT

please check

sifatnabil — Wed, 13 Jan 2016 10:03:08 GMT

Hi, that doesn't seem to work. It returns the same revenue as sum(Revenue).

sifatnabil — Wed, 13 Jan 2016 17:30:21 GMT

Found a way to get this by using addyears():

dimension:

date([Week],'D MMM')

OR more accurate: Fiscal Week Number

expression (for this year last 8 weeks) -

sum({<Date={'>=$(=WeekStart(Max(Date), -7))<=$(=Date(Max(Date)))'}>} Revenue)

expression (for last year last 8 weeks) -

sum({<Date={'>=$(=WeekStart(addyears(Max(Date),-1), -7))<=$(=Date(addyears(Max(Date),-1)))'}>} Revenue)