However, I need something that will only count weekdays, excluding holidays. In addition, for a few of the holidays (like Thanksgiving, etc) don't always fall on the same date, but rather on the same day (third Thursday of the year, etc).
Any help would be greatly appreciated. Thank you!!
Note, there is no function that returns holidays or can tell you if a date is a holiday. Holidays differ very much per country/region. You'll have to find a list of holidays that apply to your situation somewhere and load those into qlikview.
Re: Help creating Calendar that excludes weekends and holidays
That's quite an innovative question I'd ever seen on the making of the calendar control. Though I can't offer any good solution, I also feel curious on this topic. Hide weekends in calendar are some features of the control, don't know if these kind of function will contribute goods to this question or not.