topic Re: Set analysis Help in QlikView

Set analysis Help

Fri, 13 Jul 2012 15:29:18 GMT

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.

Re: Set analysis Help

CELAMBARASAN — Fri, 13 Jul 2012 15:38:07 GMT

Try this

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

Re: Set analysis Help

Fri, 13 Jul 2012 15:47:17 GMT

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.

Re: Set analysis Help

Jason_Michaelides — Fri, 13 Jul 2012 23:06:32 GMT

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

Re: Set analysis Help

stevedark — Sat, 14 Jul 2012 07:42:33 GMT

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/

Re: Set analysis Help

Jason_Michaelides — Sat, 14 Jul 2012 08:13:16 GMT

I was thinking the same thing Steve!

Re: Set analysis Help

nagaiank — Sat, 14 Jul 2012 13:22:51 GMT

Did you consider using a pivot table?