Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Using average

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

2 Replies
Highlighted
Specialist
Specialist

Re: Using average

Hi Giovanni

avg.gif

Highlighted
Not applicable

Re: Using average

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