"NETWORKDAYS" and "NAME MANAGER"

[arun2305]

Hi,

I use mostly Qlik Sense Desktop Version.

I have a formula in Excel : 

                            IF(NETWORKDAYS(StartDate;EndDate;Holidays)=0;ResolvedTime-StartTime)

I want to use it in Qlik Sense in a Sheet as a "Calculated Field".

Here "Holidays" and "StartTime" are a defined as a name in Excel. So we can change the value of it anytime. It's a kind of a variable.

And "ResolvedTime" is a field in the same the sheet.

Is it possible to do the same in Qlik Sense Desktop ?

Thank you in advance for your answer.

[pedrobergo · Accepted solution]

Hi Arun,

You can use the Networkdays function in Qlik Sense, it´s like Excel. 

NrWorkDays = Networkdays(StartDate, EndData, Holidays)

This function will return 0 if is there no workdays between Start and End Date.

See this example: Help Networkdays

To edit the Holidays you can:

1. Use a Excel spreadsheet and add it as a data source to your model.
2. Create a variable, like shows in the help example above
3. Create manually a table in the script editor or the data model manager.

Best regards,

Pedro

[arun2305]

Hi Pedro,

Thank you for your answer.

I will let you know if it worked.

Best regards, Arun

[arun2305]

Hi Pedro,

Thank you for your time and support.

It worked perfectaly.

Best regards, Arun