topic Re: Calculate % of Total in QlikView

Calculate % of Total

jagjivvt — Thu, 25 Apr 2013 13:44:47 GMT

see attached excel output from Qlik. i need to get to teh results that i have formulated in place of EE%

Thu, 25 Apr 2013 14:14:27 GMT

You can do it as you did on the attachment

it's what you want, you just have to change the name of the fields

Week	Sector	=sum([No of EE])	sum([No of EE Enroled Top 6 Pension Status])	=sum([No of EE Enroled Top 6 Pension Status])/sum(TOTAL [No of EE])
		18784	15971	85%
17/03/2013	Sector 1	2463	2079	11%
17/03/2013	Sector 2	2360	2283	12%
17/03/2013	Sector 3	52	43	0%
17/03/2013	Sector 4	4472	3798	20%
17/03/2013	Sector 5	9305	7646	41%
17/03/2013	Sector 6	132	122	1%

jagjivvt — Thu, 25 Apr 2013 14:38:52 GMT

Hi i tried that but i am using count instead of sum as the number of employee is not a number.

jagjivvt — Thu, 25 Apr 2013 15:47:05 GMT

i managed to sort this by creating summary totals in script and use these in the expressions. thanks for all you responses