Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Weighted standard deviation

Hi everybody,

I really need help in Set analysis for calculating weighted standard deviation.

The regular standard deviation formula is here:

Stdev({$<X.QID = {$(=only(X_LIST.QID))}, Y.QID = {$(=only(Y_LIST.QID))}, %RESPONDENT = {">0"}>} Y.Answer)

To calculate the weighted one I need to have a formula like:

SQRT(Sum({$<X.QID = {$(=only(X_LIST.QID))}, Y.QID = {$(=only(Y_LIST.QID))}, %RESPONDENT = {">0"}>} SQR(WEIGHT*Y.Answer-MEANW))/

Count(({$<X.QID = {$(=only(X_LIST.QID))}, Y.QID = {$(=only(Y_LIST.QID))}, %RESPONDENT = {">0"}>}  Y.Answer))

The MEANW - weighted average that was calculated before, but I don't know how to implement it into the set analysis. And if I calculate the MEANW in the STDEV  formula, I don't get any results.

Please help!

Thank you very much in advance!

2 Replies
Not applicable
Author

Have you tried using the object Statistics Box?

Not applicable
Author

Thank you for your reply. Unfortunately, I did not find a way to use the Statistics Box in my case (couldn't set expressions in there).