How to show average of only those numbers, which fit a certain condition?

[Airapport]

I have a table of numbers, let's say X.

I want to show on a chart the average of only those numbers, which are smaller than 1000.

In Excel I could do this by using a formula

=SUMIF(X:X, "<1000")/COUNTIF(X:X, "<1000")

How can I do this in QlikSense?

[MendyS]

Hi @Airapport

try to use the formula -

SUM({<x={"<1000"}>}x) / count({<x={"<1000"}>}x).

or -

avg({<x={"<1000"}>}x).
best,