Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
krishna789
Creator II
Creator II

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 II
Creator II
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;