Removing Outliers before using Fractile

[Anonymous]

I have data set which contains Columns - Vertical,Product,Metric Name and Metric Value.

The association is as such,

Vertical

     |

Product

     |

Metric Name and Value

Means - a vertical can have many products and a product can have many Metrics and Values.

Now, I'm using a bar chart with Vertical as Dimension. In expression, I used Fractile(MetricValue,0.25) to get the 25th percentile. Therefore, if the user clicks the Metrics Name(which I will give as a List box to choose from) then 25th percentile of Metric Values for that particular metric will be calculated across all Verticals.

If User Clicks a Metric Name, my chart should be like

This is where the problem lies. There are some outliers in Metric values. Because of outliers, some of the verticals were missing if I calculate Fractile().

How to use the outlier removed values in bar chart?

[Gysbert_Wassenaar]

Maybe something like Fractile({<MetricValue={">=10<=200"}>}MetricValue,0.25). Change 10 and 200 to get the range of values that you want to accept for calculating the fractiles.

If you need more help please post a small qlikview document with example data that illustrates the problem.