morning Guys

[#1]

Morning Guys,

I am using the expression below to get LAST_YEAR_TO_DATE (01-01-2014 to 21-01-2014) but I am getting the information for

01-01-2014 to 21-01-2015.......

can you guys help please if anyone have an idea......below is the expression:

Sum({<Year=, Month=, Quarter=, Week=, DateField=, DateNum={">=$(=Num(YearStart(Max(DateNum), -1)))<=$(=AddYear(Max(DateNum), -1))"}>} Sales)

the same thing is applied to LQTD for last year , LWTD for this year, PRIOR_YEAR_LWTD, LMTD

[Gysbert_Wassenaar]

Please post a qlikview document that demonstrates the problem.

[#3]

Hi Wassenaar,

wat do you mean a qlikview documents......you mean the output I get from the  expressions

[Gysbert_Wassenaar]

No, a file with a name that ends in .qvw and was created with Qlikview Desktop.