How to exclude max and min value in qlikview

[#1]

Hi

II have scenario,

I have data set like below

Year Location Sales

2016   Delhi    28

2016   Delhi     34

2016   delhi       45

2016    delhi      56

2016    delhi        23

2016    delhi       10

from the above data set i want to exclude max and min value

result

Year Location Sales

2016   Delhi    28

2016   Delhi     34

2016   delhi       45

2016    delhi        23

Is there any functions available to achieve this.

Thanks

Thiru

[Anonymous]

Hi Thiru,

A clarification to my answer, in this case I consider maximum and minimum per year and location, as I think you can have more years and locations, and you want to delete the extreme values for each location and year.

Regards!

[#3]

Thanks for all.

these all cover all possible ways to stop max and min values in qlikview both script an front end

Thanks

Thiru