Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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