topic Re: Aggregation averages/group formula help in QlikView

Aggregation averages/group formula help

Tue, 07 Feb 2017 07:00:46 GMT

I am looking for an average function where in excel it would be like above

my Qlik formula MBF/sum({$<CalYr={2014} >} MBF) is giving me 100% - I know why but have brain freeze to get right

I also am looking for one

if in Prod Group A - I want the Percentage makeup - sum({$<CalYr={yr},ProdGroup={A} > MBF)/sum({$<CalYr={yr} > }MBF)

stabben23 — Tue, 07 Feb 2017 09:08:38 GMT

Hi Cam,

You need something like this in Your Expression sum(MBF)/sum( total <ProdGroup>MBF)

Tue, 07 Feb 2017 16:23:49 GMT

What happens when you get a change in Yr - I realize my example only had 1 year, what happens with Multiple Years?

sunny_talwar — Tue, 07 Feb 2017 16:25:38 GMT

May be just this?

Sum(MBF)/Sum(TOTAL <ProdGroup, Yr> MBF)

Tue, 07 Feb 2017 16:28:56 GMT

That is probably too easy but probably correct

sunny_talwar — Tue, 07 Feb 2017 16:34:03 GMT

I guess the only way to know it would be to test it out