Skip to main content
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Sum up correct on Grand Total

Hi,

I have an issue in Qlik Sense with my measure to sum up correct on Grand Total.

My Target data is only on Group level, so I have to divide my sum measure with number of distinct SC_ID to avoid it to show the wrong figures. However, this leads to a wrong calculation on Total level.

In the example attached the right numbers should be

ID          Group          Measure

AAA      External      19650

AAA      Business     7350

AAA      Internal        11100

Total                         38100


I hope anyone can help me.

Br,

Thomas

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

SUM(Aggr(SUM(Target)/Count(Distinct SC_ID),ID,Group))

View solution in original post

2 Replies
MK_QSL
MVP
MVP

SUM(Aggr(SUM(Target)/Count(Distinct SC_ID),ID,Group))

Anonymous
Not applicable
Author

Great! Seems to work.

Thanks a lot!