Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
jcharles
Contributor III
Contributor III
‎2014-07-18 09:29 AM

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.

KEYWORDNOAMOUNTAMT PER NONO OF LEADSCOST PER LEAD
TOTAL163R1,767,380.59R10,842.834,592R389.98
Sun45R627,008.68R13,933.531,852R338.56
Move14R297,787.00R21,270.50554R537.52
Kaap35R213,786.72R6,108.19642R333.00
Family6R205,650.00R34,275.00379R542.61
krag6R111,055.50R18,509.25198R560.89
Goal6R90,732.60R15,122.10255R355.81
Iso18R80,598.01R4,477.67180R447.77
Ilanga17R69,186.35R4,069.79165R419.31
Value3R38,181.15R12,727.05102R374.33
Sonto12R24,771.86R2,064.3246R538.52
Nurse1R8,622.72R8,622.7211R783.88
Bona0R0.00-54R0.00
Drum0R0.00-38R0.00
Rights0R0.00-38R0.00
You0R0.00-38R0.00
New0R0.00-14R0.00
World0R0.00-2R0.00
Love0R0.00-2R0.00
Mthatha0R0.00-2R0.00
Khosi0R0.00-11R0.00
Kick0R0.00-1R0.00
City0R0.00-1R0.00
Times0R0.00-1R0.00
Day0R0.00-6R0.00
1,812 Views
0 Likes
1 Solution

Accepted Solutions
simenkg
Specialist
Specialist
‎2014-07-18 10:25 AM

In response to jcharles

And in the NO OF LEADS column:

Are you using COUNT(DISTINCT LEADNO) or COUNT(LEADNO)?

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

sum(AMOUNT) / sum(aggr(Count(Distinct LEADNO),KEYWORD)))


Regards
SKG

View solution in original post

1,684 Views
0 Likes
14 Replies
Anonymous
Not applicable
‎2014-07-18 09:31 AM

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

1,213 Views
0 Likes
jcharles
Contributor III
Contributor III
‎2014-07-18 09:34 AM
Author

In response to Anonymous

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.

1,213 Views
0 Likes
gmoraleswit
Partner - Creator II
Partner - Creator II
‎2014-07-18 09:35 AM

Check this: http://community.qlik.com/blogs/qlikviewdesignblog/2014/06/23/subtotals

1,213 Views
Anonymous
Not applicable
‎2014-07-18 09:36 AM

In response to jcharles

Send me your logic to get R384.88

1,213 Views
0 Likes
simenkg
Specialist
Specialist
‎2014-07-18 09:39 AM

What does your expression look like?

Try the expression:

[AMOUNT] / [NO OF LEAD]

1,213 Views
0 Likes
richard_pearce6
Luminary Alumni
Luminary Alumni
‎2014-07-18 09:56 AM

You could try an aggr()

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

Richard

1,213 Views
0 Likes
jcharles
Contributor III
Contributor III
‎2014-07-18 10:18 AM
Author

In response to Anonymous

R1767380.59 / 4592 = R384.88

sum(AMOUNT)  / COUNT(DISTINCT(LEADNO))

1,213 Views
0 Likes
jcharles
Contributor III
Contributor III
‎2014-07-18 10:19 AM
Author

In response to simenkg

I'm using :

sum(AMOUNT) / COUNT(DISTINCT(LEADNO))

1,213 Views
0 Likes
Not applicable
‎2014-07-18 10:22 AM

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

1,213 Views