Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Re: Use Total Function With Average And Aggr

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

elie_issa
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] = >}

aggr($(vNationalizationRatioLast26Weeks),Week , [Month Year],[Business Unit]))

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 ????

Capture.PNG

Re: Use Total Function With Average And Aggr

But isn't that what you wanted?

elie_issa
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.

Highlighted

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....