Set analysis to calculate average

[#1]

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.

[kaushiknsolanki]

Hi,

     There is one mistake in your expression. Correct expression is

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

Regards,

Kaushik Solanki

[Gysbert_Wassenaar · Accepted solution]

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