Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2013-08-28 06:09 AM

How to exclude National Public Holidays in Link Table(For various Dates)

Dear All,

Below mentioned are the holidays which we have. I wanted to exclude all these holidays from my calendar. I had already excluded weekdays using NETWORKING Days function. Now these National Public holidays should also needs to be excluded. Kindly help me on this...

NODATEDAYTITLE
101-Jan-2013TUESDAYNEW YEAR DAY
214-Jan-2013MONDAYMAKARA SANKRANTI / PONGAL
315-Jan-2013TUESDAYTHIRUVALLUVAR DAY
425-Jan-2013FRIDAYID MEELAD / MILAD - UN - NIBI
526-Jan-2013SATURDAYREPUBLIC DAY
615-Feb-2013FRIDAYSREE PANJAMI/ SHRI CHOTTU RAM JAYANTI/ BASANT PANCHMI
726-Mar-2013TUESDAYHOLI  FEAST / DOL JATRA
829-Mar-2013FRIDAYGOOD FRIDAY
911-Apr-2013THURSDAYCHANDRAMANA UGADI / TELUGU NEW YEAR'S DAY
GUDI PADWA/SAHID DIWAS OF S. BHAGAT SINGH, RAJGURU & SUKHDEV
1014-Apr-2013SUNDAYSOURA UGADI / TAMIL NEW YEAR'S DAY/ VAISAKHI
1101-May-2013WEDNESDAYMAY DAY / MAHARASTHRA DAY
1225-May-2013SATURDAYBUDDHA POORNIMA
1309-Aug-2013FRIDAYRAMZAN / ID-UL-FITRA
1415-Aug-2013THURSDAYINDEPENDENCE DAY
1516-Aug-2013FRIDAYDE JURE TRANSFER DAY (PONDY)
1621-Aug-2013WEDNESDAYRIG UPAKARMA/ RAKSHA BANDHAN
1728-Aug-2013WEDNESDAYJANMASHTAMI/Krishna Jayanthi
1809-Sep-2013MONDAYGANESH CHATURTHI / VINAYAKAR CHARURTHI
1902-Oct-2013WEDNESDAYGANDHI JAYANTI
2011-Oct-2013FRIDAYDURGA PUJA (Saptami)
2113-Oct-2013SUNDAYMAHANAVAMI / AYUDHA POOJA / NAVMI
2214-Oct-2013MONDAYVIJAYA DASAMI / DASAMI
2316-Oct-2013WEDNESDAYBAKRID / ED-UL-ZOHA
2418-Oct-2013FRIDAYMAHARSHI VALMIKI JAYANTI / LAKSHMI POOJA
2501-Nov-2013FRIDAYRAJYOTSAVA DAY (KARNATAKA)/ HARYANA DAY
2602-Nov-2013SATURDAYNARAKA CHATURDASI
2703-Nov-2013SUNDAYKALI POOJA / DEEPAVALI / DEEPAVALI AMAVASYA
2804-Nov-2013MONDAYPAREVA/VISWAKARMA/GOVARDHAN PUJA
2914-Nov-2013THURSDAYMUHURRAM
3025-Dec-2012WEDNESDAYCHRISTMAS 
Labels (1)
Labels
1,515 Views
0 Likes
6 Replies
MayilVahanan
MVP
MVP
‎2013-08-28 06:13 AM

Hi

NetWorkDays() funciton itself, you can able to mention the holidays list also.

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
1,232 Views
0 Likes
Not applicable
‎2013-08-28 06:37 AM
Author

In response to MayilVahanan

Hi ,

Thanks for the response could you please tell me how to exclude holidays in the networkdays????

Regards,

B.Vijayalakshmi

1,232 Views
0 Likes
techvarun
Specialist II
Specialist II
‎2013-08-28 06:39 AM

Hello Vijayalakshmi

You need to create a holiday table and update all these dates there and while computing net working days using NetWorkDays() function between two days u need to execute a query to find out what is the number of holidays between 2 days and you can directly subtract from the networkdays.

Regards

1,232 Views
techvarun
Specialist II
Specialist II
‎2013-08-28 06:41 AM

this http://community.qlik.com/thread/12770 may help u

Regards

1,232 Views
MayilVahanan
MVP
MVP
‎2013-08-28 06:41 AM

In response to

Hi

Try like this

networkdays ('2006-12-18', '2006-12-31', '2006-12-25', '2006-12-26')   returns 8

Bold dates are holidays

NetweorkDays()

Returns the number of working days (Monday-Friday) between and including start_date and end_date taking into account any optionally listed holidays. All parameters should be valid dates or timestamps.

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
1,232 Views
techvarun
Specialist II
Specialist II
‎2013-08-28 06:42 AM

http://community.qlik.com/thread/85602 again an easy example

1,232 Views
0 Likes