Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vamshi_1241
Partner - Creator
Partner - Creator

help me on Year Holidays logic

Hello experts,

I have a requirement that should show Year Holidays (Saturday, Sunday, and company holiday) as number (ex:1,2,3....). Here, if we have working days between 2 holidays, we should consider all those working days as holiday number earlier holiday number.

Example: Jan 1st, 2018 is Monday and holiday no 1, next holiday was Saturday(means Jan 6), working days between 1-6 should be considered as 1 and Saturday as no 2, then Sunday would be no 3. In the same ways, up to the next holiday, all the working days should be no 3 only.

How to write a logic for this in script level? Please help me, thanks in advance.

0 Replies