average calculations on straight table

[ReddyQsQv]

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

[cengizeralp]

Hi ReddyQsQv,

This expression can be

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

regards,

cengiz

[ReddyQsQv]

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

[Brett_Bleess]

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