topic Re: Sum / Aggregate Only providing first value in QlikView

Sum / Aggregate Only providing first value

villegasi03 — Tue, 25 Mar 2014 18:37:14 GMT

Looking for some assistance with a similar post regarding sum product. I have had a similar problem as the post below but I have an additional dimension as he does not.

http://community.qlik.com/message/300618#300618

I am getting this Using (SUM(AGGR(SUM(Workload), Employeeid)) 😞

Employee	Workgroup	Answered	Handle Time	WG Workload	Global Workload
Employee, One	Workgroup1	173	374	64702	81,679
Employee, One	Workgroup2	15	314	4710
Employee, One	Workgroup3	47	261	12267
Employee, Two	Workgroup1	140	286	40040	122,210
Employee, Two	Workgroup2	61	931	56791
Employee, Two	Workgroup3	17	637	10829
Employee, Two	Workgroup4	50	291	14550
Employee, Three	Workgroup1	8	465	3720	14,340
Employee, Three	Workgroup2	24	320	7680
Employee, Three	Workgroup3	6	318	1908
Employee, Three	Workgroup4	3	344	1032

Woud like to get this:

Employee	Workgroup	Answered	Handle Time	WG Workload	Global Workload
Employee, One	Workgroup1	173	374	64702	81,679
Employee, One	Workgroup2	15	314	4710	81,679
Employee, One	Workgroup3	47	261	12267	81,679
Employee, Two	Workgroup1	140	286	40040	122,210
Employee, Two	Workgroup2	61	931	56791	122,225
Employee, Two	Workgroup3	17	637	10829	122,225
Employee, Two	Workgroup4	50	291	14550	122,225
Employee, Three	Workgroup1	8	465	3720	14,340
Employee, Three	Workgroup2	24	320	7680	14,340
Employee, Three	Workgroup3	6	318	1908	14,340
Employee, Three	Workgroup4	3	344	1032	14,340

Re: Sum / Aggregate Only providing first value

Tue, 25 Mar 2014 18:52:15 GMT

Attached with answer. I did a back-end calculation.

Thanks

Re: Sum / Aggregate Only providing first value

swuehl — Tue, 25 Mar 2014 18:57:45 GMT

Try

=sum(total<Employeeid> Workload)

Re: Sum / Aggregate Only providing first value

villegasi03 — Tue, 25 Mar 2014 19:01:28 GMT

IT WORKED THANK YOU SOOOOO MUCH

Re: Sum / Aggregate Only providing first value

srchilukoori — Tue, 25 Mar 2014 19:02:36 GMT

AGGR will evaluate one value in this situation.

A workaround is to use Sum(total <Employee ID> [WG Workload])

Re: Sum / Aggregate Only providing first value

maxgro — Tue, 25 Mar 2014 19:03:57 GMT

perhaps this?

SUM(TOTAL <Employee> AGGR(SUM([WG Workload]), Employee))