topic Re: average calculations on straight table in QlikView

average calculations on straight table

ReddyQsQv — Sat, 16 Nov 2024 19:11:15 GMT

Score	Values
200	4
0	6
100	2
_	3
100	1
200	1
_	2
_	2

200*4+0*6+100*2+100*1+200*1/4+6+2+1+1
this need to be written in expression level

when the score is '-' , the values against blank should not consider for the Avg calculation

please help me in writing the expression for it not in the script level

Re: average calculations on straight table

cengizeralp — Mon, 03 Feb 2020 18:22:01 GMT

Hi ReddyQsQv,

This expression can be

sum(Score*Values)/Sum({<Score={">=0"}>}Values)

regards,

cengiz

Re: average calculations on straight table

ReddyQsQv — Wed, 05 Feb 2020 09:39:28 GMT

Hi Cengiz

Thank you so much for your reply

but in this case when >= 0 it is not considering the 6 when the score is 0

it should not count for the values when it has null not for the 0

Re: average calculations on straight table

Brett_Bleess — Wed, 26 Feb 2020 17:46:08 GMT

Have a look at the following Design Blog post, I believe it may fill in some gaps for you:

https://community.qlik.com/t5/Qlik-Design-Blog/Accumulations/ba-p/1466581

Here is the base URL for the Design Blog area in case you wish to do some further searching for other posts in that area, most are how-to related just FYI.

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett