Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

toedegaard
New Contributor II

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

Re: Sum up correct on Grand Total

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

2 Replies

Re: Sum up correct on Grand Total

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

toedegaard
New Contributor II

Re: Sum up correct on Grand Total

Great! Seems to work.

Thanks a lot!