Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Aggregating data for a chart - newbie is stuck

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 NameUser NameProject NameTask NameTime Spent
ABCBobABC-TeamABC100-Basic0.25
ABCJimABC-TeamABC100-Extended0.25
ABCBobABC-TeamABC100-Extended1.0
ZYXJaneZY-TeamZYX100-Basic6
GHIJimGHI-TeamGHI-100-Dev5
ZYXJimZY-TeamZYX100-Dev10

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)

Tags (2)
1 Solution

Accepted Solutions
Not applicable

Re: Aggregating data for a chart - newbie is stuck

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

i'm not sure i understand your aggr ideaSmiley Happy

2 Replies
Not applicable

Re: Aggregating data for a chart - newbie is stuck

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

i'm not sure i understand your aggr ideaSmiley Happy

Not applicable

Re: Aggregating data for a chart - newbie is stuck

DOH!

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

Community Browser