Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Not applicable

ealize the function УРЕЗСРЕДНЕЕ (TRIMMEAN)

I have an array of goods with the sales documents.

need to realize the function УРЕЗСРЕДНЕЕ (TRIMMEAN).

a function something like median and average, but selects data at a rate of.

Established Coefficient variables

example:

1

2

4

8

16

32

64

128

256

512

1024

2048

УРЕЗСРЕДНЕЕ (A1: A12; 0,1) = 341,25

УРЕЗСРЕДНЕЕ (A1: A12; 0,4) = 127,5

УРЕЗСРЕДНЕЕ (A1: A12; 0,6) = 84

TRIMMEAN (A1: A12; 0,1) = 341,25

TRIMMEAN (A1: A12; 0,4) = 127,5

TRIMMEAN (A1: A12; 0,6) = 84

Community Browser