Removing Outliers before using Fractile

Anonymous — Wed, 04 Nov 2015 11:08:44 GMT

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?

Re: Removing Outliers before using Fractile

Gysbert_Wassenaar — Thu, 05 Nov 2015 09:05:10 GMT

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.

topic Removing Outliers before using Fractile in QlikView

Removing Outliers before using Fractile

Re: Removing Outliers before using Fractile