
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to calculate average score
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hope it helps!

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I tried it but still doesn't work 😔

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 ?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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])

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Not sure I am able to follow... would you be able to share a sample to show your issue?
.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
