# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for
Did you mean:
Contributor III

## Total does not add up

Good day

I have a chart where every column's total adds up correctly except for the last column which should show the total as R384.88 but it shows R389.98. I don't know why. Can someone help please.

 KEYWORD NO AMOUNT AMT PER NO NO OF LEADS COST PER LEAD TOTAL 163 R1,767,380.59 R10,842.83 4,592 R389.98 Sun 45 R627,008.68 R13,933.53 1,852 R338.56 Move 14 R297,787.00 R21,270.50 554 R537.52 Kaap 35 R213,786.72 R6,108.19 642 R333.00 Family 6 R205,650.00 R34,275.00 379 R542.61 krag 6 R111,055.50 R18,509.25 198 R560.89 Goal 6 R90,732.60 R15,122.10 255 R355.81 Iso 18 R80,598.01 R4,477.67 180 R447.77 Ilanga 17 R69,186.35 R4,069.79 165 R419.31 Value 3 R38,181.15 R12,727.05 102 R374.33 Sonto 12 R24,771.86 R2,064.32 46 R538.52 Nurse 1 R8,622.72 R8,622.72 11 R783.88 Bona 0 R0.00 - 54 R0.00 Drum 0 R0.00 - 38 R0.00 Rights 0 R0.00 - 38 R0.00 You 0 R0.00 - 38 R0.00 New 0 R0.00 - 14 R0.00 World 0 R0.00 - 2 R0.00 Love 0 R0.00 - 2 R0.00 Mthatha 0 R0.00 - 2 R0.00 Khosi 0 R0.00 - 11 R0.00 Kick 0 R0.00 - 1 R0.00 City 0 R0.00 - 1 R0.00 Times 0 R0.00 - 1 R0.00 Day 0 R0.00 - 6 R0.00
1 Solution

Accepted Solutions
Partner

And in the NO OF LEADS column:

This would explain the wrong total if there are some LEADNO that exists for more than one KEYWORD. It would then only be counted once in the total.

If sum(AMOUNT) / COUNT( LEADNO) does not work, try

Regards
SKG

14 Replies
Specialist

Check in the properties whether you have used "Expression Totals" or Sum Totals.

Contributor III
Author

I'm using the expression total. I cannot change it to sum of rows total because then it gives me R5 232.20 which is also incorrect.

Partner
Specialist

Send me your logic to get R384.88

Partner

What does your expression look like?

Try the expression:

Luminary Alumni

You could try an aggr()

Avg ( Aggr ( <Your Expression> , KEYWORD ) )

Richard

Contributor III
Author

R1767380.59 / 4592 = R384.88

Contributor III
Author

I'm using :

Not applicable

If you have tried all of the above it may mean that you have a disconnect in your data somewhere.