topic Re: morning Guys in QlikView

morning Guys

Thu, 22 Jan 2015 08:06:51 GMT

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 — Thu, 22 Jan 2015 08:59:33 GMT

Please post a qlikview document that demonstrates the problem.

Thu, 22 Jan 2015 09:13:22 GMT

Hi Wassenaar,

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

Gysbert_Wassenaar — Thu, 22 Jan 2015 09:19:48 GMT

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