Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
pauldamen
Partner - Creator II
Partner - Creator II

Workdays per month Aggr to Quarter

All,

I have a calculation were we calculate the average workdays per month for a country or region (region is average, on country level the average is just that number) for example: country 1 has 20 workdays, country 2 has 22. The average for the region is 21.

Now I need to have the # of workdays for a Quarter which should be calculated by adding the average of month 1 + month 2 + month 3. But how can I achieve this, because of the average is always calculate the average even with the quarter as a dimension, taking this average and do it times 3 causes differences so that doesn't work either.

Help is much appreciated.

Regards,

Paul

1 Reply
swuehl
MVP
MVP

I believe that you shouldn't add the averages, but calculate the workdays per quarter per country and average across countries.

If you tell us more about how you calculate the workdays and in what context you are doing this, I think someone can suggest a way to do this.