Set analysis Help

[#1]

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.

[CELAMBARASAN]

Try this

=aggr(sum(TimeReportedActual),TechID,UserGroup)

[#3]

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.

[Jason_Michaelides]

Can you provide a sample app or at least some example data and what you want the result to be?

[stevedark]

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

http://www.quickintelligence.co.uk/

[Jason_Michaelides]

I was thinking the same thing Steve!

[nagaiank]

Did you consider using a pivot table?