BD Days Logic

[Anonymous]

Can someone help me to calculate the below logic in Qlik Sense (Column) same as Networking days in Excel

BD = Closed Date – Opened Date – Saturday & Sunday( in between the Closed date & Opened Date) – List of Holidays

Thanks

Deepanshu

[Gysbert_Wassenaar · Accepted solution]

You can use the Networkdays function for this. It will calculate the working days only between two dates. You can pass it a list of holidays to exclude those days too. See the help file for more information: http://help.qlik.com/sense/2.1/en-US/online/#../Subsystems/Hub/Content/Scripting/DateAndTimeFunction...

[Anonymous]

Thanks a lot for the help!!!!

One more query I need a filter in script for date for Eg. Date > 8/31/2015

Can you please guide me in this part

Thanks

Deepanshu

[Gysbert_Wassenaar]

Please start a new discussion for your question. And explain in that discussion what do you want to do? Can you post a small qlik sense app that explains the problem?

[Anonymous]

Sure. Thanks

Post a question in the below link. I am unable to post the qvd file as Qlik is installed in some other system and I am not able to get the file from that system

Filter

Thanks

Deepanshu