Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Not applicable

Removing top 5 and bottom 5 values

Hi,

   I need to find the average of overall experience values every month. The trick is that the average is done by reoving the top5 and bottom 5 values. Eg, if we have 100 values we need to average from 6 to 95. Any ideas on how to do it? Either in scripting or chart expression is appreciated.Thanks in Advance.

2 Replies
Highlighted
Partner
Partner

Re: Removing top 5 and bottom 5 values

hei

attach is an example

the text box contains the formula that you asked

Highlighted
MVP & Luminary
MVP & Luminary

Removing top 5 and bottom 5 values

See the Qikview Cookbook example "Removing outlier values from a chart dimension." for some options.

-Rob

http://robwunderlich.com