Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
So I have a column "Date" going back 20 years, I need to find a formula that will identify the 4th Thursday of November as Thanksgiving
It depends a bit on the context in which you use it. If you had a chart with a Year dimension, a measure like this would return the Thanksgiving date for each Year:
aggr(nodistinct min({<Date={"=Weekday(Date)=4 and Month(Date)=11"}>}Date, 4), Year)
-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com