Calculate Standart deviation

[employe4_2]

Hi

i'm displaying a Line chart and i want to show the standart deviation. I understaood i need to use Stdev function in reference line section but , it seems to give me doubtfulll results.

any one know how to use that function ?

[JordyWegman]

Hi,

What do you want to create? Something like this?

Standard Deviation

Maybe you can show what your formula is?

Check the Qlik help for explanation of the formula. 

Also, check this earlier post, because I think you probably need something like this.

Jordy

Climber

[employe4_2]

yeah its kinda what i want, 

except i use a scatter plot X : time Y : value ; and and i ask  for the chart to display the "bubbles" with a specific color depending of their value ( if  value > average + standart deviation then color is red, else blue)

this is the idea: this is the formula for the standart deviation.

and i use this condition for the color, but it gives me non logical results : 

if(

avg({<OP_name={'OP03'}>}[End.of.Position.])+3*Stdev({<OP_name={'OP03'}>}[End.of.Position.]) < [End.of.Position.] and avg({<OP_name={'OP03'}>}[End.of.Position.])-3*Stdev({<OP_name={'OP03'}>}[End.of.Position.])>[End.of.Position.],
LightGreen(),
LightRed()
)

the reference line draw above some "bubbles"  the line 3 sigma but those bubbles don't seems to change color appropriately ...