Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikuser222
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
sunny_talwar

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
sunny_talwar

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

qlikuser222
Creator
Creator
Author

Hi,

Thanks for reply.

Weekends and also dates in Holiday table to be excluded.

Thanks

sunny_talwar

May be this

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