Discussion Board for collaboration related to QlikView App Development.
I am trying to achieve some thing like
stdev(IF abs(val - Valmedian) < ( Valmedian*10), val)
i am trying to create a set expression where i can do median of the val which are less than 10% of total median
Valmedian - is total median without any selection and
Val - is actual value.
Something like a ZScore.
Can any one please advise.
More Explanation required, Your Expression is bit Difficult, Can i know what you want to Achieve?
Try if this works, because you can only compare dimensions with variables in set analysis
create a variable
vEval = IF(abs(val - Valmedian) < ( Valmedian*10), val)
in your chart use : STDEV($(vEval))
Can you please post sample Application?