topic Re: Average in QlikView

Average

fanninam — Wed, 25 Nov 2020 16:16:04 GMT

I'm trying to get the following statement to take an average of the EjFTE:

Sum({$<HCOE={'Human Costs'},[Year]={$(=Only(Year))}>}Actaul_Amount)/Sum({<[Years]={$(=(Only(Years)))}>}(EjFTE))

Re: Average

Thu, 06 Apr 2017 18:43:12 GMT

Please provide screenshot of what you are getting with the above expression and what are you expecting in the end result.

Re: Average

MK_QSL — Thu, 06 Apr 2017 18:47:57 GMT

Replace Only with Max

Re: Average

mendoncart — Thu, 06 Apr 2017 18:49:49 GMT

Hi.

I'm a noob on Qlik, but I'll try to help, in return of all the help I got here.

Are you getting any result out of this formula?

I think you're missing some quotes.

If this is the case, assuming the rest is right, try this:

Sum({$<HCOE={'Human Costs'},[Year]={'$(=Only(Year))'}>}Actaul_Amount)/Sum({<[Years]={'$(=(Only(Years)))'}>}(EjFTE))

Maybe I'm completely wrong. I hope not. But if I am, someone with more knowledge will aid.

Re: Average

Thu, 06 Apr 2017 18:57:35 GMT

Hello,

To get the average you should divide it by count. You have Sum/Sum. That doesn't look right.

What is EjFTE? is it a text field?

And when you use Only , make sure you have only one value selected in Year field. only returns only one value, if it finds multiple possible values in year then it will return null.