Problem to get Last Year Same day value

[#1]

Hello Everyone,

I have DATE( current Year) , PYDate indicates Last year date of the current year Day

For example : current date is sep 17th - Wednesday, week3,

                       The PY date is showing Sep 18th-2013 - Wednesday, week 3, the logic is like this.

I need to get previous year values, i tried using by create a key at script level,, but it is not working, it is not giving expected results

Can anybody tell how to to get previous year values based on the Date and PYDate association.

Thanks

[Anonymous]

can you post your qvw file here:

I assume you need something like:

Today() as Date

AddMonths(Today(), -12) as PYDate

[tresesco]

You have to create additional fields in the script(if not already there) that gives you WeekNo (May be using LunarWeek idea) and WeekDay.

Or, have a look here :http://community.qlik.com/blogs/qlikviewdesignblog/2014/03/03/ytd for another idea.

[vikasmahajan]

Sending you Like wise qvw file please checked if this could help you.

Vikas@