New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Average of a range of data

Hello Everyone,

I'm trying to calculate in a KPI the average of only data that are above 46400 kilograms. (Peso Bruto), i don't need the average of the whole table.

Regards,

Gerd Neumann.

1 Solution

Accepted Solutions
Valued Contributor

Re: Average of a range of data

avg(if(weight>46400,YourFieldToAverage))

or using set analysis

avg( {\$<weight={">46400"}>} YourFieldToAverage )

3 Replies
Valued Contributor

Re: Average of a range of data

avg(if(weight>46400,YourFieldToAverage))

or using set analysis

avg( {\$<weight={">46400"}>} YourFieldToAverage )

MVP & Luminary

Re: Average of a range of data

HI,

Try using set analysis like below

=Avg( {<[Peso Bruto]={">46400"}>} [Peso Bruto])

Hope this helps you.

Regards,

Jagan.

Not applicable

Re: Average of a range of data

This works for me.

Regards,

Gerd Neumann

Community Browser