Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Partner
Partner

average

How to find average of all the month for each person

1 Solution

Accepted Solutions
Partner
Partner

Re: average

Hi. You can reach it by some ways.

First is divide for amount of monthes like (your expression)/count(distinct [Month] & [Year])

Second is using AGGR function like avg(aggr(your expression, [person], [Month], [Year]))

[Year] field is optional in case of many years of data.

1 Reply
Partner
Partner

Re: average

Hi. You can reach it by some ways.

First is divide for amount of monthes like (your expression)/count(distinct [Month] & [Year])

Second is using AGGR function like avg(aggr(your expression, [person], [Month], [Year]))

[Year] field is optional in case of many years of data.