topic Re: Standard Deviation in QlikView

Standard Deviation

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Standard Deviation

sunny_talwar — Mon, 09 Oct 2017 17:09:36 GMT

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

Standard deviation - Wikipedia

Re: Standard Deviation

lorenzoconforti — Mon, 09 Oct 2017 20:27:36 GMT

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

Re: Standard Deviation

MarcoWedel — Mon, 09 Oct 2017 20:43:20 GMT

Hi,

one example

hope this helps

regards

Marco