Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Standard Deviation

Hi

I am working on finding the standard deviation for a list of times from purchased to delivery. I followed the examples in other feeds but I need clarification.

Basically I subtracted the purchased time from the delivered and came up with a new list of time labeled purchasetodeliv.

I created a set analysis for this but unsure if it is correct or not.

Stdev({$< [Status Code]={'Black Shirts'}>}purchasetodeliv)

purchasetodeliv (in hours)

60.5

70.7

19.3

230.1

145

555.6

26.7

3 Replies
sunny_talwar

Syntax looks right to me... is there anything wrong with the output you get?

Not applicable
Author

Its just that the deviation looks high so I was not sure if I was doing the right thing.

Thanks for the clarification.

ankur_abhishek
Contributor III
Contributor III

Hi Kurleigh,

Formula is correct it stddev should come around 190.20. Refer the below screenshot for reference . It is derived from using your data set values


Captuggre.JPG