Set analysis expression to calculate the average

[Anonymous]

Hello,

I was wondering if I could get some help please.

I am attempting to use an expression to calculate the average total sales for the month in qlikview to put in my summary table.

The raw data displays multiple sales for each day. So I would need to first sum the sales for each business day and then calculate the average for total sales for each day of that month. I have attached an example of the raw data and the desired result which can be achieved in excel. I would like to identify a simple expression to perform this calculation so that I can add it to my pivot summary table in qlikview.

Thanks,

Esther

[Anil_Babu_Samineni]

use this?

Avg(Aggr(If(Plan = 'Average', Sum(Deposits)), Month, Date))

[sunny_talwar]

I would suggest you to use set analysis like this

Avg({<Plan = {'Average'}>}Aggr(Sum({<Plan = {'Average'}>}Deposits), Month, Date)))

and you might also need to add Plan to the Aggr() function here

Avg({<Plan = {'Average'}>}Aggr(Sum({<Plan = {'Average'}>} Deposits), Month, Date, Plan)))