Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
richardm90
Partner - Contributor III
Partner - Contributor III

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
sunny_talwar

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

View solution in original post

6 Replies
sunny_talwar

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
Partner - Contributor III
Partner - Contributor III
Author

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
Partner - Contributor III
Partner - Contributor III
Author

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
Partner - Contributor III
Partner - Contributor III
Author

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