topic Re: Average orders per day using weekdays in QlikView

Average orders per day using weekdays

Thu, 23 May 2013 15:44:41 GMT

Hi all,.

I am trying to calculate the average number or work orders per day but only taking into account weekdays

I think i need to use the network days function but am unsure how to write the expression.

My fields are

CountWorkOrder

avg(CountWorkOrder) will give me the average between the time scale selected, but i only want it to work it out per day over weekdays.

Can anyone help?

Re: Average orders per day using weekdays

Thu, 23 May 2013 16:24:53 GMT

Hi,

You can use the WeekDay() function:

IF(WeekDay(date_used) <> 'Sunday', AVG (CountWorkOrder))

Rebeca

Re: Average orders per day using weekdays

Gysbert_Wassenaar — Thu, 23 May 2013 17:40:09 GMT

Try avg({<MyDate={'=networkdays(MyDate,MyDate)'}>}CountWorkOrder)

Re: Average orders per day using weekdays

akuttler — Wed, 04 Oct 2017 22:08:10 GMT

Hello,

I have the same issue... I am trying to calculate Average Patient Visits per day for Weekdays only in given date range. My Field Names are 'Date of Service' and 'Visits'. I tried IF(WeekDay('Date of Service') <>'Sunday', AVG (VISITS))

The expression was accepted but It made no difference.