Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I'm trying to make a straight table that shows my 'usergroups', distinct 'TechID's', and those peoples 'ActualTimeReported'.
I want it to sort out by UserGroup but only include distinct TechID's and then sum up the ActualTimeReported for those distinct TechID's.
I tried something like this as my expression...
=
aggr(sum(distinct({$< 'TechID'={}>}TechID)TimeReportedActual)UserGroup)...With my dimension of Usergroup
Obviously it doesnt work. Any help would be great. Thanks.
Try this
=aggr(sum(TimeReportedActual),TechID,UserGroup)
That did not work. It only works when I drill down for some of the Usergroups.
I want to sum up, given a user group, each distinct 'TechID's' 'ActualTimeReported' and display each 'TechID' individually with the sum of their 'ActualTimeReported'.
Not summing up the 'ActualTimeReported' for each usergroup and just showing the sum.
Can you provide a sample app or at least some example data and what you want the result to be?
Hi there,
I think I must be missing something, but what you describe sounds like a straight table chart with two dimensions (User Group and Tech ID) and an expression ( sum(ActualTimeReported) ). QlikView by it's very nature will then show a list of distinct user groups and tech id's with the sum next to it. If you want to show each user group just once change the view to a Pivot and make it always fully expanded.
As Jason suggests a sample app and description of desired result would certainly help us get our heads around the problem!
Steve
I was thinking the same thing Steve!
Did you consider using a pivot table?