Skip to main content

New to Qlik Sense

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

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
mnvrma
Partner - Contributor III
Partner - Contributor III

Error with Sum function

Screenshot (40).png

 

I want to calculate the sum of  "Actual Weighted Score" by Year, name but as I'm using the sum function it's giving me Sum of all "Actual Weighted Score" Value which is related to that year and name.

for Ex::- (Year-2012 and Name-Abhijit Gargate)

Sum("Actual Weighted Score") giving me 7.5+7.5+7.5+7.5+7.5+1.5+0 and so on equal to 166.75

But I want it as 7.5+1.5+0 and so on .

I don't want to sum for all value with same QuestionGroup(Which is 3rd column)

Load
Year,
Name,
Sum("Actual Weighted Score") as "Total Of Actual Weighted Score"
Resident Calc
Group By Year,Name;

2 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

As long as there is only one value for the weighted score for each QuestionGroup, then this should do the trick:

=Sum(Aggr(Only([Actual Weighted Score]), QuestionGroup))

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Vegar
MVP
MVP

Maybe Sum(DISTINCT [Actual Weighted Score]) will solve your issue?