Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi @Airapport
try to use the formula -
SUM({<x={"<1000"}>}x) / count({<x={"<1000"}>}x).
or -
avg({<x={"<1000"}>}x).
best,