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.
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
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.
I've managed to get this to work now. Thanks again for your help.
What did you do to make it work?
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
That is awesome!! Thanks for sharing what went wrong.
Retrieving data ...