topic Set analysis to calculate average in QlikView

Set analysis to calculate average

Wed, 03 Apr 2013 10:36:08 GMT

Hello guys, I have used set analysis to calculate average in a gauge. This is the formula:

=avg({$<[DepartmentAssuranceFlag] = {"0}, RiskName={'CPD'}>} Rating)

The score is 2.78

However, if I work out the average in Excel the score is 2.52 (See attachment for clarity)

Could you please confirm that my QV formula is correct? If not, could you pleasesuggest right formula to calculate the average, given the conditions in the formula?

Thank you for your support.

Re: Set analysis to calculate average

kaushiknsolanki — Wed, 03 Apr 2013 11:24:51 GMT

Hi,

There is one mistake in your expression. Correct expression is

=avg({$<[DepartmentAssuranceFlag] = {"0"}, RiskName={'CPD'}>} Rating)

Regards,

Kaushik Solanki

Re: Set analysis to calculate average

Gysbert_Wassenaar — Wed, 03 Apr 2013 11:25:27 GMT

Based on your excel file and using your expression (minus the typo) I get as average 2.57 in both Qlikview and in Excel.

avg({$<[DepartmentAssuranceFlag] = {0}, RiskName={'CPD'}>} Rating) yields 2.57