Statistically clean data in dashboard

[#1]

Hello Everyone,

   I am new to the world of Qlikview, and right now I am enjoying it. My current dashboard involves analyzing user provided data, which of course provides its own challenges with respect to quality.

My question is, is there a way to clean the data using statistics, for instance, removing any data more the X std dev away?

[chiru_thota]

Welcome & All the best !

yes you can....but describe more about  your problem with data.(QVW).

Have look Statistics functions.

[rwunderlich]

See this example in the QV Cookbook

http://qlikviewcookbook.com/recipes/download-info/outliers/

for an example of removing outliers from a chart.

-Rob

[#4]

My app concerns showing a competitive pricing database's information.  This information is supplied by salespeople in the field.  So lets say my company deals with widgets and the average price of a widget is $1,000.00.  Some users have put in erroneous information, for example, a widget that costs $1.00 or $1MM.  These records are clearly the result of user error but enough of these errors will skew the data and can lead to bad decisions.  My goal is to use statistics and say "If the price of a widget is X standard deviations from the mean, remove/hide it from the usable/viewable data set".

Thanks for your help.