Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
why don't you use simply sum([Time Spend])
i'm not sure i understand your aggr idea:)
why don't you use simply sum([Time Spend])
i'm not sure i understand your aggr idea:)
DOH!
Yeah, thats it - I was too busy looking for something complex. Thanks.