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

Set analysis sum value between 2 values doesn't work

Michiel_QV_Fan — Sun, 29 Apr 2018 18:17:59 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:05:48 GMT

please don't create multiple threads for the same question:

Set analysis sum value between 2 values doesn't work

thanks

regards

Marco

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

Michiel_QV_Fan — Mon, 30 Apr 2018 06:38:02 GMT

my browser froze, apparantly the post was done therefore a duplicate..