This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I want the no. of non working days between two dates.
I know we can find no. of working days using NetWorkDays function. but this function returns only working working days which i don't want. I want only no. of non working days.
actuall i want to discard bank holidays and weekend between two dates difference.
You don't have to attach weekend dates because "NetWorkDays" yet exclude them, so your expression will be:Suppose yìthat you want to analysìze all 2013:Num('31/12/2013'-'01/01/2013'+1-NetWorkDays('01/01/2013','31/12/2013', all your holydays date)
View solution in original post
('30/06/2013'-'01/06/2013') +1- NetWorkDays('01/06/2013', '30/06/2013', '02/06/2013')
Thank you for reply.
yes it will helpful. Actually i have list of bank holidays with comma seprator but i also want to attach weekend dates between two dates in this list. Can you please help me in this?
Thank you very much. It will help me.