Standard Deviation in Qlikview

[#1]

Hi All, i want to calculate a standard deviation into a chart in Qlikview. did anyone know how to use Standard Deviation formula in Qlikview

[shane_spencer · Accepted solution]

stdev (data)

I use it for measuring "peak" utilisation by x2 and adding on to Avg.

[#3]

Hi Shane, i have three field, ( CustID, Range, Count). i am displaying "Range" wise sum of Count "=Sum(Count)" in bar Chart. i replace this formula with "Stdev(Count)" . CustID is my deminstion, so when no CustID is selected it shows the standard deviation value or when i select more than 1 CustID it shows .. but when i select any single CustID it say's "No data to display" Regards, Jitendra

[shane_spencer]

Isn't that because the standard deviation of a single object is zero? Surely you need more than 1 object to get a standard deviation.

Please remember mark the answer as correct. Thanx