Solved: Why is avg() not working as expected for the Total... - Qlik Community

NenadV · ‎2024-09-11

ExpressionData

NenadV · ‎2024-09-11

I know, I've fixed the issue in the data script by replacing zeroes with 0.5 for those who haven't scored anything.

Case closed. Thank you all.

View solution in original post

Or · ‎2024-09-11

Presumably, you've got some form of zero-value suppression turned on?

PrashantSangle · ‎2024-09-11

assuming 47.7% is not correct & 75.3 % is correct? can you explain how you got the 75.3%? if you are doing avg of rows then you have to use below option

Regards,

Prashant Sangle

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

NenadV · ‎2024-09-11

no

NenadV · ‎2024-09-11

I know. It result with the same total score

PrashantSangle · ‎2024-09-11

great. then what is the issue?

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Or · ‎2024-09-11

I'd suggest you double-check that. Zero suppression or another form of limitation (such as Top N) is by far the most common reason for what you're describing.

Kushal_Chawda · ‎2024-09-11

@NenadV One possibility is that you have duplicate values for the combination of dimension you are using. Try aggregating values like below

= avg(aggr(avg(OS_Score), IBP_Cycle, Attendee))

NenadV · ‎2024-09-11

it could be these

how to overcome it as there are no limitations?

NenadV · ‎2024-09-11

ok, thx.

this formula doesn't work as it result with -

Why is avg() not working as expected for the Total?

Client Managed

Layout & Visualizations