Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

richardm90
New Contributor II

Count Networkdays

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.

1 Solution

Accepted Solutions

Re: Count Networkdays

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

6 Replies

Re: Count Networkdays

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
New Contributor II

Re: Count Networkdays

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
New Contributor II

Re: Count Networkdays

Hi Sunny,

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

Highlighted

Re: Count Networkdays

What did you do to make it work?

richardm90
New Contributor II

Re: Count Networkdays

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

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

Best,

Sunny

Community Browser