Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Partner
Partner

Exclude Weekends and Holidays Qlik Sense

I am working  on a Data Set. I need to ignore the Weekends and USA Public Holidays.  I need to build a Master calendar for these dates . For example if you look at the chart on Monday it will show previous day data that is Friday (Not Sat or Sun) or ignore any Holidays.

Attached please find the sample data set.  

Please attach a QVF for solution

2 Replies
simonc-cfn
New Contributor III

Re: Exclude Weekends and Holidays Qlik Sense

I assume you searched the community and did not find the answer you seek.

I found this thread that may provide some guidance.  Hope it helps.

https://community.qlik.com/t5/QlikView-Documents/Master-Calendar-with-Working-days-Holidays-Flag/ta-...

Simon

Support
Support

Re: Exclude Weekends and Holidays Qlik Sense

One thing you may take a look is the function Weekday() where you can get as return, the day of the week for each date record.
After getting it, you can use an expression that will not display dates where weekday = 'Sat' or 'Sun'.

To help users find verified answers, please don't forget to mark a correct resolution or answer to your problem or question as correct.