Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have this list box full of Metrics Name.
Metrics Name |
---|
A |
B |
C |
D |
E |
Each Metric has a value for several ID's. Say
ID | Metric Name | Metric Value |
---|---|---|
1 | A | 20.0 |
2 | A | 10.5 |
3 | A | 12.6 |
Likewise, it goes on for all the ID's and each Metric. My requirement is to come up with a benchmark value for a Particular Metric. This is the Algorithm I found online (Box and Whiskers Plot Algorithm)
1. Sort the values for a particular Metric in ascending order.
2. If there are more than 10 values (count), then do the following (else Chart should not be displayed for that metric)
2.1. Find Q1 = Fractile (MetricValue,0.25)
2.2. Find Q2 = Fractile (MetricValue,0.5)
2.3. Find Q3 = Fractile (MetricValue,0.75)
2.4. Find IQR = Q3-Q1
2.5. Find LB = Q1 - 1.5 * IQR
2.6. Find UB = Q3 + 1.5 * IQR
2.7. The values Lower than LB and higher than UB should be eliminated.
3. If (MetricType='Some Type', Fractile(MetricValue,0.85), Fractile(MetricValue,0.15)
This Algorithm needs to be implemented in Chart Expression, so that if a Metric is selected, the Chart will be shown accordingly.
I'm not sure, whether this is possible in Qlikview. It would be great if someone can throw some light on this.
I'm attaching the Sample working of the Algorithm in an Excel File.
See Recipe for a Box Plot. It is not exactly the same, but the calculations are similar.
HIC
Thanks a lot Henric. Let me Check whether it works for me