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)
