# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

MVP

## Re: Use Total Function With Average And Aggr

Will it be possible to share a sample to look at this?

Contributor II

## Re: Use Total Function With Average And Aggr

This is the expression i am using :

avg(TOTAL{<Month = , Year = , [Month Year] = , [Week Year] = >}

The above expression is giving the correct % for May which is 26.03% but it showing the same percentage for all the other months :S

What should I add to the Expression To get the same result gotten for May for the other Months ????

MVP

## Re: Use Total Function With Average And Aggr

But isn't that what you wanted?

Contributor II

## Re: Use Total Function With Average And Aggr

No I want to get the Average of Last 26 weeks for May which is showing now 26.03 %

And for April 2018 it should show 25.65 % which is the average of the last 26 weeks from April 2018.

It's complicated I know hope it's Clear now.

MVP

## Re: Use Total Function With Average And Aggr

I suggest you to use The As-Of Table if you are able to make changes in the script. If not, then you will need Missing Manual - Above() and Below() functions to solve this. Set Analysis isn't going to work here....