topic Re: Networkdays with if statements in QlikView

Networkdays with if statements

Tue, 14 Mar 2017 15:49:07 GMT

Hi All,

I need to work out the average number of days between two dates using dimensions as to filter out irrelevant results.

could anyone provide help with this formula?

Re: Networkdays with if statements

sunny_talwar — Tue, 14 Mar 2017 16:34:17 GMT

Would you be able to share some sample data and what is the expected output from that sample?

Re: Networkdays with if statements

Tue, 14 Mar 2017 16:42:12 GMT

Hi Sunny,

I cant show you the data but I will show you the formula:

=networkdays([Schedule for Interview],[Interview Arranged])

This is whats in their currently, however I need to work out the average which the standard formula doesn't seem to work?

and then I want to add in an If statement to only include [Interview Arranged] with values in.

Hope this makes sense and any help would be greatly appreciated.

Kind regards

Re: Networkdays with if statements

sunny_talwar — Tue, 14 Mar 2017 17:58:02 GMT

This is whats in their currently, however I need to work out the average which the standard formula doesn't seem to work?

and then I want to add in an If statement to only include [Interview Arranged] with values in.

I am still not sure what average you wish to calculate here and what is the if statement here?

QlikCommunity Tip: How to get answers to your post?