Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
greend21
Creator III
Creator III

Calculating Average with Set Analysis

I'm trying to find out the average calls per day but only  for work days. In my data, the sum(#of Calls) is 0 on non working days so maybe I could calculate the data by excluding those days where the sum(#ofCalls)=0, so maybe a count of that. I was thinking this would be some sourt of sum(#ofcalls)/Count(pick(match())) but I am not completely sure. I now think this might need set analysis.

Any help is greatly appreciated!

10 Replies
Anonymous
Not applicable

Maybe

Avg(if(weekday(DateField)<5,[#of Calls]))