topic Re: BD Days Logic in App Development

BD Days Logic

Anonymous — Wed, 06 Jan 2016 14:04:23 GMT

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

Re: BD Days Logic

Gysbert_Wassenaar — Wed, 06 Jan 2016 17:50:44 GMT

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/DateAndTimeFunctions/networkdays.htm

Re: BD Days Logic

Anonymous — Wed, 06 Jan 2016 19:26:44 GMT

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

Re: BD Days Logic

Gysbert_Wassenaar — Thu, 07 Jan 2016 18:56:21 GMT

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?

Re: BD Days Logic

Anonymous — Fri, 08 Jan 2016 18:05:05 GMT

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