Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Setanalysis in calendar script

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

3 Replies

Re: Setanalysis in calendar script

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

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

YearStart(ToDay(),-3) as StartOfFiscalYear

YearStart(ToDay()) as StartOfYear


talk is cheap, supply exceeds demand
Not applicable

Re: Setanalysis in calendar script

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

Not applicable

Re: Setanalysis in calendar script

Sorry To make all the things mess up

Calendar with flags making set analysis so very simple

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)
Community Browser