Standard Deviation

[Anonymous]

Hi guys,

I have got a requirement to implement upper and lower bound in a line chart using standard deviation in QV.

But I don't know the use and purpose of standard deviation. Could anyone give me a brief explanation on how it works and its purpose?

Thanks,

Siva.

[sunny_talwar]

Have you looked outside of QlikView? May be look here:

Standard deviation - Wikipedia

[lorenzoconforti]

Upper and lower bound make more sense when used with confidence interval (Confidence Intervals), rather than just standard deviation

Assuming your distribution of values follows a normal distribution, you'll need to understand what level of confidence the user wants to assess (or you can give the option to select it manually)

Then by using the function NORMDIST (NORMDIST ‒ QlikView) you can calculate the two values you'll need to plot on your chart

If you post some data I'm sure we can help

[MarcoWedel]

Hi,

one example

hope this helps

regards

Marco