topic sum over sum question (sample included) in QlikView

sum over sum question (sample included)

amien — Wed, 31 Mar 2010 21:52:08 GMT

If someone could help me out .. that would really be great,

i have this code in an expression. in dimension i have a user and a team.

in a new expression i want the sum of the sum, based on team level.

cause there are more users in a team, the value will be the same for each user within the team.

Thanks in advanced


(sum(calls) / sum(TOTAL <user> calls))
*
(sum(total <user> duration)+sum(total <user> talktime))

sum over sum question (sample included)

amien — Thu, 01 Apr 2010 08:17:38 GMT

if anyone got some spare time 🙂

sum over sum question (sample included)

Thu, 01 Apr 2010 08:58:00 GMT

Amien,

it seems it takes a while get it to work.

Rainer

sum over sum question (sample included)

Thu, 01 Apr 2010 11:23:15 GMT

Hi Amien,

not able to upload an example at the moment. I can provide an accumulation by team.

Not exactly what you want but a step forward.

RangeSum(User, Above(Team))

Name your columns and use the expression above as example.

Another idea is to calculate some figures during load in the script (Sum, Group By).

And hopfully then are calculations are easier by expressions in an object.

Rainer

sum over sum question (sample included)

amien — Thu, 01 Apr 2010 12:11:41 GMT

thanks for your reply . .but not working .. let me try to simplfy

see. attachment

user,team,expression

expression:


(sum(calls) / sum(TOTAL <user> calls))
*
(sum(total <user> duration)+sum(total <user> talktime))
<pre>
these values show the values i need
now i want to remove the user dimension.
when i do that, the expression doesnt show the right values. The sum on team level is not working.
tried to add <team,user> instead of <user> but isnt correct too
 </body>

sum over sum question (sample included)

Thu, 01 Apr 2010 13:39:45 GMT

Amien,

here are the example (accumulation) I was talking about.

The other lines, objects are some experiments.

Rainer

sum over sum question (sample included)

amien — Thu, 01 Apr 2010 14:20:14 GMT

in your 'accumulation i was talking about'

team1,user 1 shows 924,44

but

team1, user 3 shows 4571,11

while both should show 4571,11

sum over sum question (sample included)

amien — Fri, 02 Apr 2010 13:08:16 GMT

i will simplify my question.

see screenshot:

dimensions: user, team

expression:

sum(calls) / sum(TOTAL <user> calls))
*
(sum(duration)+sum(talktime))

this is all correct. Now i want to delete the user dimension. Result will be that the expression will be summed. But this not correctly summed

See attachment in first post.

load script cant be altered .. i'm looking for an expression solution

sum over sum question (sample included)

amien — Sat, 03 Apr 2010 10:07:43 GMT

Rainer

I could make this with using the load script, but looking for an expression.

going to make a new thread and be more specific.

Thanks for your time