Discussion Board for collaboration related to Creating Analytics for QlikView.
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))
I wanted to calculated standard Deviation of all employee val's . who is less than median of 10% of all employees
val is a numeric value of each employee. In above case the vEval stores only single value. but i want all vEval who is less than 10% median.
Th variable will aggregate for each dimension, try it in your chart first
Can you please post sample Application?