Set Analysis with weighted average

Fri, 25 Sep 2015 14:23:36 GMT

Hi,

I'm trying to script a set analysis using the calculation of weighted standard deviation as my base expression and ignoring the selection of Qtr Yr.

The calculation for wtd avg is:

sum([Yr Denominator Value]*[Yr Measure Value])/sum([Yr Denominator Value])

The yearly values are not calculated in qlikview itself but is aggregated into tables in our ETL process. So, I typically use ONLY as the function when calling on those fields in set analysis.

I'm assuming the expression should look something like:

=ONLY({<[Qtr Yr]=>}sum([Yr Denominator Value]*[Yr Measure Value])/sum([Yr Denominator Value]))

but this is obviously not correct. Any direction on how to tackle this would be greatly appreciated.

Thanks.

Re: Set Analysis with weighted average

MK_QSL — Fri, 25 Sep 2015 14:49:13 GMT

May be

Avg(Aggr(sum([Yr Denominator Value]*[Yr Measure Value])/sum([Yr Denominator Value]),YourYearFIeld))

Re: Set Analysis with weighted average

Fri, 25 Sep 2015 18:15:23 GMT

Thank you, Manish.

Is there a way to also exclude selections for a certain field ( in my case )?

topic Re: Set Analysis with weighted average in QlikView

Set Analysis with weighted average

Re: Set Analysis with weighted average

Re: Set Analysis with weighted average