Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
MIKIEMILLER
Contributor III
Contributor III

Finding Thanksgiving

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

 

 

Labels (4)
1 Reply
rwunderlich

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