topic Re: Count Networkdays in App Development

Count Networkdays

richardm90 — Fri, 22 Dec 2017 12:12:54 GMT

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.

Re: Count Networkdays

sunny_talwar — Fri, 22 Dec 2017 16:20:12 GMT

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

Re: Count Networkdays

richardm90 — Tue, 02 Jan 2018 09:44:37 GMT

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.

Re: Count Networkdays

richardm90 — Tue, 02 Jan 2018 14:49:04 GMT

Hi Sunny,

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

Re: Count Networkdays

sunny_talwar — Tue, 02 Jan 2018 16:50:15 GMT

What did you do to make it work?

Re: Count Networkdays

richardm90 — Tue, 02 Jan 2018 16:53:17 GMT

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.

Re: Count Networkdays

sunny_talwar — Tue, 02 Jan 2018 17:14:48 GMT

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

Best,

Sunny