Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
gouthamkk
Contributor

Set Analysis with calculation

Hi,

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.

6 Replies

Re: Set Analysis with calculation

More Explanation required, Your Expression is bit Difficult, Can i know what you want to Achieve?

Life is so rich, and we need to respect to the life !!!
vinieme12
Esteemed Contributor II

Re: Set Analysis with calculation

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))

gouthamkk
Contributor

Re: Set Analysis with calculation

HI,

I wanted to calculated standard Deviation of all employee val's . who is less than median of 10% of all employees

gouthamkk
Contributor

Re: Set Analysis with calculation

Hi

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.

Highlighted
vinieme12
Esteemed Contributor II

Re: Set Analysis with calculation

Th variable will aggregate for each dimension, try it in your chart first

Re: Set Analysis with calculation

Can you please post sample Application?

Life is so rich, and we need to respect to the life !!!
Community Browser