topic Re: Identifying outliers through standard deviation in QlikView https://community.qlik.com/t5/QlikView/Identifying-outliers-through-standard-deviation/m-p/1061817#M465280 <HTML><HEAD></HEAD><BODY><P>Hello, can someone explain how this is done? I can't import files in the personal edition.</P><P></P><P>Thanks!</P></BODY></HTML> Mon, 15 May 2017 08:09:37 GMT 2017-05-15T08:09:37Z Identifying outliers through standard deviation https://community.qlik.com/t5/QlikView/Identifying-outliers-through-standard-deviation/m-p/1061813#M465276 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I'm trying to find outliers in my data using standard deviation but I'm not sure how to go about doing this.</P><P></P><P>I have multiple standard deviations based on the category of salesman.&nbsp; I want to find which salesmen are beyond the standard deviation of sales for that particular category, so to speak.</P><P></P><P>Can anyone help me with this?</P><P></P><P>Thank you in advance.</P></BODY></HTML> Wed, 23 Mar 2016 21:46:56 GMT https://community.qlik.com/t5/QlikView/Identifying-outliers-through-standard-deviation/m-p/1061813#M465276 Anonymous 2016-03-23T21:46:56Z Re: Identifying outliers through standard deviation https://community.qlik.com/t5/QlikView/Identifying-outliers-through-standard-deviation/m-p/1061814#M465277 <HTML><HEAD></HEAD><BODY><P>Could you post some sample lines of records, best using a small sample QVW?</P></BODY></HTML> Wed, 23 Mar 2016 21:49:36 GMT https://community.qlik.com/t5/QlikView/Identifying-outliers-through-standard-deviation/m-p/1061814#M465277 swuehl 2016-03-23T21:49:36Z Re: Identifying outliers through standard deviation https://community.qlik.com/t5/QlikView/Identifying-outliers-through-standard-deviation/m-p/1061815#M465278 <HTML><HEAD></HEAD><BODY><P>Maybe like attached?</P></BODY></HTML> Wed, 23 Mar 2016 23:21:22 GMT https://community.qlik.com/t5/QlikView/Identifying-outliers-through-standard-deviation/m-p/1061815#M465278 swuehl 2016-03-23T23:21:22Z Re: Identifying outliers through standard deviation https://community.qlik.com/t5/QlikView/Identifying-outliers-through-standard-deviation/m-p/1061816#M465279 <HTML><HEAD></HEAD><BODY><P>Yes, this is what I was looking for.&nbsp; I knew it had to be simple and that I was just over-thinking the problem.</P><P>Thank you so much swuehl!</P></BODY></HTML> Thu, 24 Mar 2016 13:20:43 GMT https://community.qlik.com/t5/QlikView/Identifying-outliers-through-standard-deviation/m-p/1061816#M465279 Anonymous 2016-03-24T13:20:43Z Re: Identifying outliers through standard deviation https://community.qlik.com/t5/QlikView/Identifying-outliers-through-standard-deviation/m-p/1061817#M465280 <HTML><HEAD></HEAD><BODY><P>Hello, can someone explain how this is done? I can't import files in the personal edition.</P><P></P><P>Thanks!</P></BODY></HTML> Mon, 15 May 2017 08:09:37 GMT https://community.qlik.com/t5/QlikView/Identifying-outliers-through-standard-deviation/m-p/1061817#M465280 2017-05-15T08:09:37Z Re: Identifying outliers through standard deviation https://community.qlik.com/t5/QlikView/Identifying-outliers-through-standard-deviation/m-p/1061818#M465281 <HTML><HEAD></HEAD><BODY><P>Hi Filippo,</P><P></P><P>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</P><P></P><P>If&nbsp; the absolute value of sales value minus the average of the sales values is greater than the stddev, then it is an outlier.</P></BODY></HTML> Mon, 13 Aug 2018 13:27:28 GMT https://community.qlik.com/t5/QlikView/Identifying-outliers-through-standard-deviation/m-p/1061818#M465281 pamelabremer 2018-08-13T13:27:28Z