Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I tried it but still doesn't work 😔
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 ?
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])
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
Not sure I am able to follow... would you be able to share a sample to show your issue?
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