Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
luca_bellotti
Contributor III
Contributor III

Week day year Average

Hello everyone,

I have the following tables:

Sales:
LOAD

ID,
Shop,
Category,
Date,
Sales;

Calendar:

LOAD

Date,
WeekDay,
NrWeek;

 What I need to get is an average per week day of the whole year.

In the app I've created a table to check everyday if some sales are missing from the dataset:

table.PNG

Aside I created another table where I would like to have the average per week day:

Result.PNG

AvgSales = Avg(Aggr(Sum(Sales),WeekDay)

As you can see this is not the average but the sum.

What can I do to get the average?

 

Thanks in advance.

 

 

Labels (3)
10 Replies
rbartley
Specialist II
Specialist II

If I export the data to Excel and create a pivot table that includes the WeekDay and Average of Sales, the results are as follows (the same as in my previous post).  So how exactly are you calculating the average?  
AvWeeklySalesExcel.JPG