Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Please post a qlikview document that demonstrates the problem.
Hi Wassenaar,
wat do you mean a qlikview documents......you mean the output I get from the expressions
No, a file with a name that ends in .qvw and was created with Qlikview Desktop.