topic Re: Problem to get Last Year Same day value in QlikView

Problem to get Last Year Same day value

Wed, 17 Sep 2014 07:07:42 GMT

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 — Wed, 17 Sep 2014 07:40:42 GMT

can you post your qvw file here:

I assume you need something like:

Today() as Date

AddMonths(Today(), -12) as PYDate

tresB — Wed, 17 Sep 2014 07:42:18 GMT

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

vikasmahajan — Wed, 17 Sep 2014 08:14:25 GMT

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

Vikas@