topic Re: funcion sum with one dimension in App Development

funcion sum with one dimension

lpenya31 — Sat, 16 Nov 2024 16:59:58 GMT

Hi!

I'm trying to create this table on qliksense, but it seems I'm not able to find the right formula to calculate the average category price, without filtering by the products that you have in the second row.

I would like to create a formula that just takes into account the category (product category) but not the single product, in order to calculate the average price by category, not by product.

I have been trying the following formula but it doesn't work for me:

avg(total<ProductCategory>if(ProductPrice>0,ProductPrice))

Thank you for your help!

Re: funcion sum with one dimension

stevejoyce — Wed, 15 Sep 2021 15:57:15 GMT

does this work for you:

avg(total<ProductCategory> {<ProductPrice={">0"} >} ProductPrice)

Re: funcion sum with one dimension

lpenya31 — Tue, 26 Oct 2021 14:42:40 GMT

Hello Stevejoyce

I have tried your formula but it does not calculate anything for me.

Re: funcion sum with one dimension

stevejoyce — Tue, 26 Oct 2021 15:19:43 GMT

Are you getting any syntax issue? Not sure if your field names are different then what you posted.

Can you post a sample data set. This should work.