Aggregating data for a chart - newbie is stuck

Mon, 10 Sep 2012 11:57:41 GMT

HI,

I'm in a bind and need a little assistance.

It's been a coupl eof years since I used Qlikview and I've just found out how VERY rusty I am (so I'm considering my self a beginner now)

I have a xls with the following fields

sample data.

Client Name	User Name	Project Name	Task Name	Time Spent
ABC	Bob	ABC-Team	ABC100-Basic	0.25
ABC	Jim	ABC-Team	ABC100-Extended	0.25
ABC	Bob	ABC-Team	ABC100-Extended	1.0
ZYX	Jane	ZY-Team	ZYX100-Basic	6
GHI	Jim	GHI-Team	GHI-100-Dev	5
ZYX	Jim	ZY-Team	ZYX100-Dev	10

What I want to do is create a bar chart that will tell me the total time for each client name.

I /thought/ I could set it up with a dimension of Client Name, and set the expression as sum(aggr(sum( [Time Spent]), [User Name]))

However that's giving me wild results that don't tally up with the original spreadsheet either for individual clients or for the total.

eg the bar chart would show 600 for client ZYX, yet when I select just ZYX it correctly shows 3.5

All helpgratefully received.

(In the mean time I'll be in the corner with my Dunce cap on)

Re: Aggregating data for a chart - newbie is stuck

Mon, 10 Sep 2012 12:25:08 GMT

why don't you use simply sum([Time Spend])

i'm not sure i understand your aggr idea:)

Mon, 10 Sep 2012 12:40:38 GMT

DOH!

Yeah, thats it - I was too busy looking for something complex. Thanks.