topic how to code a sum with only values above certain value? in QlikView

how to code a sum with only values above certain value?

Tue, 11 Aug 2015 21:59:41 GMT

Hello,

I been trying for a while now and cant find a way to discriminate certain values of a table. To make it short, I want the sells average of products with a sell above $50,000. Example:

Products	Sells
Product 1	10,000
Product 2	60,000
Product 3	70,500
Product 4	45,000
Product 5	50,200

Expected result	60,233

This result come from (Product 2+Product 3+Product 5)/3

Thank you in advance.

Re: how to code a sum with only values above certain value?

swuehl — Tue, 11 Aug 2015 22:04:46 GMT

Try something like this in a text box:

=Avg( {<ProductField = {"=sum(SellingField)>50000"}>} Aggr( Sum(SellingField), ProductField ))

Replace ProductField and SellingField with your appropriate field names.

Re: how to code a sum with only values above certain value?

Tue, 11 Aug 2015 22:30:31 GMT

Thanks a lot!!!! it worked perfectly