Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bruce_sorge
Contributor III
Contributor III

Average one column based on another column's content

Greetings, 

Apologies if this has  been covered, I may not be wording it correctly to get the answer. 

I have a spreadsheet that has several columns. I have one column named Altmetric Score, and another called National Research Program. The data looks like this:

National Research ProgramAltmetric Score
ACE99
CSS25
SSWR65
ACE48
CSS534

 

My bar chart looks like this:

bruce_sorge_0-1595872003705.png

 

What it's doing is averaging out ACE correctly, but then it's taking the average of SSWR, and adding it to ACE. Then it's taking that total, and adding it to CSS, ect. I tried using the aggregate function inside my avg function but to no avail. Below is my expression that gets this particular result:

Avg([Altmetric Score])

 

Thanks,
Bruce

Labels (1)
0 Replies