topic Re: Setanalysis in calendar script in QlikView

Setanalysis in calendar script

Mon, 08 Feb 2016 17:14:33 GMT

I am trying to add these to my calendar script could any one help me on that

Same business day of the prior year (so today being Monday 2/8/16 what happened on Monday 2/9/15)
Same business week of the prior year (so this week being 2/8 - 2/12/16, last year same time period 2/9 - 2/13/15)
Based on date chosen, what is last fiscal year to date (so for FY 16 would be 10/1/15 to today 2/8/16)
Based on date chosen, what is last calendar year to date (so for this year would be 1/1/16 to today 2/8/16)

Thank you

Gysbert_Wassenaar — Mon, 08 Feb 2016 17:47:35 GMT

LastWorkDay(AddYears(ToDay(),-1) as BusinessDayPriorYear

WeekStart(LastWorkDay(AddYears(ToDay(),-1)) as BusinessWeekPriorYear

YearStart(ToDay(),-3) as StartOfFiscalYear

YearStart(ToDay()) as StartOfYear

Mon, 08 Feb 2016 19:06:24 GMT

Thank you Can i get the expressions for those so that i can employ them directly in straight table

Mon, 08 Feb 2016 19:44:17 GMT

Sorry To make all the things mess up

in that Zip file you will find a .qvw

in the same script i need these to be built.

Same business day of the prior year (so today being Monday 2/8/16 what happened on Monday 2/9/15)
Same business week of the prior year (so this week being 2/8 - 2/12/16, last year same time period 2/9 - 2/13/15)
Based on date chosen, what is last fiscal year to date (so for FY 16 would be 10/1/15 to today 2/8/16)
Based on date chosen, what is last calendar year to date (so for this year would be 1/1/16 to today 2/8/16)