Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Identifying outliers through standard deviation

Hello,

I'm trying to find outliers in my data using standard deviation but I'm not sure how to go about doing this.

I have multiple standard deviations based on the category of salesman.  I want to find which salesmen are beyond the standard deviation of sales for that particular category, so to speak.

Can anyone help me with this?

Thank you in advance.

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Maybe like attached?

View solution in original post

5 Replies
swuehl
MVP
MVP

Could you post some sample lines of records, best using a small sample QVW?

swuehl
MVP
MVP

Maybe like attached?

Anonymous
Not applicable
Author

Yes, this is what I was looking for.  I knew it had to be simple and that I was just over-thinking the problem.

Thank you so much swuehl!

Not applicable
Author

Hello, can someone explain how this is done? I can't import files in the personal edition.

Thanks!

pamelabremer
Partner - Contributor III
Partner - Contributor III

Hi Filippo,

In case you still needed this solution, I just stumbled upon it because it is useful to me too. The basic concept in the application is that each sales value is compared to the stddev

If  the absolute value of sales value minus the average of the sales values is greater than the stddev, then it is an outlier.