Discussion Board for collaboration related to QlikView App Development.
how to find weekago function example 2012,2013
listbox should be 1-104th
Please check this
Create Indicator for 4, 8, and 13 weeks ago in Calendar
i got it with that reference link .
,53*(Year($(vMaxDate))-Year ([DATE])) + week($(vMaxDate) ) - week( [DATE]) as weekAgo.
Please close this thread with marking correct answer it will helpful to another one.
date(makedate(2015) + rowno() -1) as d
let vMaxDate = Today();
left join (D)
DIV('$(vMaxDate)' - d, 7) as WeekAgo