topic Pivot - Show StdDev in New Column in QlikView https://community.qlik.com/t5/QlikView/Pivot-Show-StdDev-in-New-Column/m-p/910410#M316144 <HTML><HEAD></HEAD><BODY><P>Hello. See attached. I'm looking for a way to show outliers in a pivot table. The data is dead simple -- some items with process times (in days). The item may be made in one of three locations (shown across the top). What I want to do is identify the outliers. In my data set, 19E in Portland has a process time of 50 days, while it's 20 at the other locations. Item MM1 is a red flag also. </P><P></P><P>One thought was to add a column to the far right that shows the standard deviation of the process times across all locations. I can't figure out how to get the column over there. If I add an expression, it shows for each location, which makes sense, but it's not what I want. Is there a way to aggregate at that level? Or maybe a better way altogether? </P><P></P><P>Thanks for taking a look. </P></BODY></HTML> Tue, 04 Aug 2015 14:51:12 GMT 2015-08-04T14:51:12Z Pivot - Show StdDev in New Column https://community.qlik.com/t5/QlikView/Pivot-Show-StdDev-in-New-Column/m-p/910410#M316144 <HTML><HEAD></HEAD><BODY><P>Hello. See attached. I'm looking for a way to show outliers in a pivot table. The data is dead simple -- some items with process times (in days). The item may be made in one of three locations (shown across the top). What I want to do is identify the outliers. In my data set, 19E in Portland has a process time of 50 days, while it's 20 at the other locations. Item MM1 is a red flag also. </P><P></P><P>One thought was to add a column to the far right that shows the standard deviation of the process times across all locations. I can't figure out how to get the column over there. If I add an expression, it shows for each location, which makes sense, but it's not what I want. Is there a way to aggregate at that level? Or maybe a better way altogether? </P><P></P><P>Thanks for taking a look. </P></BODY></HTML> Tue, 04 Aug 2015 14:51:12 GMT https://community.qlik.com/t5/QlikView/Pivot-Show-StdDev-in-New-Column/m-p/910410#M316144 2015-08-04T14:51:12Z