Qlik Community

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.

Captura de pantalla 2015-12-22 a las 4.45.17 p.m..png

Regards,

Gerd Neumann.

1 Solution

Accepted Solutions
paul_scotchford
Valued Contributor

Re: Average of a range of data

avg(if(weight>46400,YourFieldToAverage))

or using set analysis

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

3 Replies
paul_scotchford
Valued Contributor

Re: Average of a range of data

avg(if(weight>46400,YourFieldToAverage))

or using set analysis

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

MVP & Luminary
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