topic Using average in QlikView

Using average

Wed, 25 Nov 2020 16:16:04 GMT

Hi everyone,

i need some help to create an average expression.

I have this siuation:

Pivot Table

1st dimension is a "group dimension" and the user can select different dimensions with the drill down button

2nd dimension is the yearmonth, used in columns

the expression is the sum(sales)

i need to have a second expression that calculate the average of sales for all the yearmonth

i attach an excel file that explain what i mean... i need the expression in column G

could you help me to reproduce it in qlikview?

thanks in advance

el_aprendiz111 — Thu, 25 May 2017 19:39:28 GMT

Hi Giovanni

Fri, 26 May 2017 06:51:18 GMT

Thanks Fer Fer!

but and if i want to use the average in a calucaltion?

For example i need to have for every yearmonth the difference from the average

See the excel for an example

and another thing, is possible to choose a range for the average calculation? for example the average af the last 3 yearmonths

thanks in advance