Count Networkdays

[richardm90]

Hi All,

I'm trying to create a KPI in my Qlik Sense app that shows the number (and one that shows the percentage) of the networkdays results that are <= 10 days.

I've so far tried this:

count(networkdays("Submission date", "Start Date")) <=10

Any help would be much appreciated.

[sunny_talwar · Accepted solution]

May be like this

Sum(Aggr(If(NetWorkDays("Submission date", "Start Date") <= 10, 1, 0), Dimension/s))

Dimension/s would be the dimension over which you are checking your condition of NetWorkDays() <= 10

[richardm90]

Hi,

Thank you very much for your help on this, I have tried this formula but getting the response of 10 when I know that 95% of the records are 10 networkdays or less. Any further pointers on this would be much appreciated,

I have the dimension set as the customer name.

[richardm90]

Hi Sunny,

I've managed to get this to work now. Thanks again for your help.

[sunny_talwar]

What did you do to make it work?

[richardm90]

The dimension I was using wasn't a unique ID across all records so it wasn't an accurate result, I was using the client name (some clients have multiple records).

Now that I've changed this to a unique ID it works great

Thanks again.

[sunny_talwar]

That is awesome!! Thanks for sharing what went wrong.

Best,

Sunny