Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Standard Deviation in Qlikview

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

1 Solution

Accepted Solutions
shane_spencer
Specialist
Specialist

stdev (data)

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

View solution in original post

3 Replies
shane_spencer
Specialist
Specialist

stdev (data)

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

Not applicable
Author

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
Specialist
Specialist

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