Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
jagjivvt
Creator
Creator

Calculate % of Total

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

1 Solution

Accepted Solutions
jagjivvt
Creator
Creator
Author

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

View solution in original post

3 Replies
Not applicable

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























































WeekSector=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])
   
187841597185%
17/03/2013Sector 12463207911%
17/03/2013Sector 22360228312%
17/03/2013Sector 352430%
17/03/2013Sector 44472379820%
17/03/2013Sector 59305764641%
17/03/2013Sector 61321221%
jagjivvt
Creator
Creator
Author

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

jagjivvt
Creator
Creator
Author

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

View solution in original post