Set analysis sum value between 2 values doesn't work

Michiel_QV_Fan — Sun, 29 Apr 2018 18:16:25 GMT

I created this expression:

sum({1<[CE.cijfer_thesis] = {">$(=avg([CE.cijfer_thesis])-Stdev([CE.cijfer_thesis]))<$(=avg([CE.cijfer_thesis])+Stdev([CE.cijfer_thesis]))">} [CE.cijfer])

which gives this result:

and that is correct but the result of the sum does not show anything (a '-')

What am I missing here?

Re: Set analysis sum value between 2 values doesn't work

MarcoWedel — Sun, 29 Apr 2018 20:04:51 GMT

missing closing bracket:

sum({1<[CE.cijfer_thesis] = {">$(=avg([CE.cijfer_thesis])-Stdev([CE.cijfer_thesis]))<$(=avg([CE.cijfer_thesis])+Stdev([CE.cijfer_thesis]))"}>} [CE.cijfer])

hope this helps

regards

Marco

topic Re: Set analysis sum value between 2 values doesn't work in QlikView

Set analysis sum value between 2 values doesn't work

Re: Set analysis sum value between 2 values doesn't work