Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
krishna789
Creator
Creator

how to find weekago function?

how to find weekago function example 2012,2013

listbox should be 1-104th

4 Replies
prma7799
Master III
Master III

krishna789
Creator
Creator
Author

thanks PM

i got it with that reference link .

weekago:

,53*(Year($(vMaxDate))-Year ([DATE])) + week($(vMaxDate) ) - week( [DATE]) as weekAgo.

prma7799
Master III
Master III

Please close this thread with marking correct answer it will helpful to another one.

maxgro
MVP
MVP

😧

load

date(makedate(2015) + rowno() -1) as d

AutoGenerate 365*3;

let vMaxDate = Today();

left join (D)

load

d,

DIV('$(vMaxDate)' - d, 7) as WeekAgo

Resident D;