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
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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,820 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,692 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,219 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,219 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,219 Views
Anonymous
Not applicable
‎2014-07-18 09:36 AM

In response to jcharles

Send me your logic to get R384.88

1,219 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,219 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,219 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,219 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,219 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,219 Views