Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
March 11, 2PM EST: Do More with Qlik - Getting Started wtih Qlik Sense SaaS - Redux. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Prabhu1204
Creator
Creator

Average in Pivot Table

Could you please help me on the below scenario.

 

I need to calculate Average Weight of the Site.

 

Need output. I used  the below formula and getting the right answer but the  site YYYY having (-) value. I need to display avg score on both of the site value.
=aggr(Sum(Score)/count(Score),ID)

RegionSitesIDAverage Weight  Given by sites for all the region ( AS per ID)
AXXX147.5
YYYY147.5
BXXX232
    
Original Data  
RegionSitesIDScore
AXXX145
AYYYY150
BXXX232

 

 

-Prabhu
Labels (1)
1 Solution

Accepted Solutions
sunny_talwar

@Prabhu1204 May be this?

 

Sum(TOTAL <ID> Score)/Count(TOTAL <ID> Score)

 

View solution in original post

2 Replies
sunny_talwar

@Prabhu1204 May be this?

 

Sum(TOTAL <ID> Score)/Count(TOTAL <ID> Score)

 

View solution in original post

Prabhu1204
Creator
Creator

Thank you

-Prabhu