Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Avg working days??

Hi Everyone,

I have a requirement where I need to calculate the avg. sales for given working days which excludes weekend and holidays.

Please find attached file which explains my requirement.

Can anyone please help me?

Thanks

1 Solution

Accepted Solutions
Highlighted

Re: Avg working days??

May be this

=Sum(Sale)/NetWorkDays(Min(Date), Max(Date), $(=Concat(DISTINCT {<Holiday = {'*'}>} Chr(39) & Date & Chr(39), ', ')))

View solution in original post

3 Replies
Highlighted

Re: Avg working days??

Isn't 12th a Sunday and should not be counted also? Or do we only exclude dates which are in Holidays table?

Highlighted
Creator
Creator

Re: Avg working days??

Hi,

Thanks for reply.

Weekends and also dates in Holiday table to be excluded.

Thanks

Highlighted

Re: Avg working days??

May be this

=Sum(Sale)/NetWorkDays(Min(Date), Max(Date), $(=Concat(DISTINCT {<Holiday = {'*'}>} Chr(39) & Date & Chr(39), ', ')))

View solution in original post