funcion sum with one dimension

[lpenya31]

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! 

[stevejoyce · Accepted solution]

does this work for you:

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

[lpenya31]

Hello Stevejoyce 

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

[stevejoyce]

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.