Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
see attached excel output from Qlik. i need to get to teh results that i have formulated in place of EE%
i managed to sort this by creating summary totals in script and use these in the expressions. thanks for all you responses
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% |
Hi i tried that but i am using count instead of sum as the number of employee is not a number.
i managed to sort this by creating summary totals in script and use these in the expressions. thanks for all you responses