# QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Rules, plus terms and conditions, can be found here.
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.

6 Replies
MVP

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

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

Highlighted
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.

Esteemed Contributor II

## Re: Set Analysis with calculation

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

MVP

## Re: Set Analysis with calculation

Can you please post sample Application?

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