topic Re: How to calculate average score in QlikView

How to calculate average score

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

Hello,

Please Help me, I want calculate average for score but not work

=AVG({<CONTENT = {[ONLINE DISCUSSION BOARD],[CASE STUDY],[ROLE PLAYING],[STORY TELLING],[LEARNING CONTES]}>} SCORE )and {<PROGRAM = {[JOIN VISIT]}>} [TOTAL SCORE JV] )

Thanks you

Re: How to calculate average score

TimvB — Thu, 30 Jan 2020 20:38:42 GMT

You set analysis is incorrect for two reasons: (1) it is only possible to define one set analysis section in an expression, and (2) it is mot possible to include a field in the value section. This explains set analysis: https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/ChartFunctions/SetAnalysis/set-analysis-expressions.htm

Hope it helps!

Re: How to calculate average score

Fia_Fiia — Fri, 31 Jan 2020 09:40:52 GMT

I tried it but still doesn't work 😔

Re: How to calculate average score

El_Davidus — Fri, 31 Jan 2020 13:07:53 GMT

Hello Fia.

For me it is easier to create another column in script mode and apply that for whatever reason afterwards.

Did you get it ?

Re: How to calculate average score

sunny_talwar — Fri, 31 Jan 2020 13:12:53 GMT

Are you trying to find the Avg or SCORE field or TOTAL SCORE JV? If it is TOTAL SCORE JV... then try this

=Avg({<CONTENT = {[ONLINE DISCUSSION BOARD], [CASE STUDY], [ROLE PLAYING], [STORY TELLING], [LEARNING CONTES]}, PROGRAM = {[JOIN VISIT]}>} [TOTAL SCORE JV])

Re: How to calculate average score

Fia_Fiia — Wed, 05 Feb 2020 10:07:43 GMT

Thanks for your help, my calculation change now.

Please Help me, how to calculate this =AVG({<Program = {[ACTIVE LEARNING]},Content = {[ONLINE DISCUSSION BOARD],[CASE STUDY],[ROLE PLAYING],[STORY TELLING],[LEARNING CONTES]}>} [Nilai MQ])

If All content values zero, I want in this calculation the result is zero (0), in my formula, if all content has no value, it becomes a #VALUE!

Please Help me

Thank you

Re: How to calculate average score

sunny_talwar — Wed, 05 Feb 2020 12:51:55 GMT

Not sure I am able to follow... would you be able to share a sample to show your issue?

Re: How to calculate average score

Brett_Bleess — Mon, 24 Feb 2020 20:08:18 GMT

You can also check out the following Design Blog post on Set Analysis, it may be a bit more helpful than the Help, as the poster goes into things in a bit more detail, so it may help you understand better what you may be getting incorrect. There are some further related posts at the bottom too, just FYI.

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

Regards,
Brett