Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot Table Average problem

Hi I have brands and products in the dimension of the table. I want to take the average of their score in the pivot table:

Brand NameProduct NameScoreavg

Brand 1

Product 1100250
Brand 1Product 2200250
Brand 1Product 3300250
Brand 1Product 4400250

I want to make the table as shown above when the dimensions are all expanded. When I collapse the product name field, it works well but when I expand it, it will show the exact value of the score on the avg field.Can you help me doing this?

Thank you

13 Replies
MK_QSL
MVP
MVP

AVG({1}TOTAL <[Brand Name]> Score)

michael_maeuser
Partner Ambassador
Partner Ambassador

avg(TOTAL score)

Roop
Specialist
Specialist

Sum(Score) / count(Product Name)

would work too in this example.

It depends on exactly what you want. The difficulty comes if some of the values are zero and they need to be counted as well.

R

Not applicable
Author

Thanks for help. I solved it. The problem occured because of the calculated dimension. After copying calculated dimension to the set analysis. the avg function will work.