How to calculate the % of a sub-group within a group

[#1]

Hi all,

Refer to the right hand side table, I would like to calculate the % of Prod A with LOW Class to the WHOLE group.

i.e.

• PROD A - LOW Class = 11/39
• PROD A - HIGH Class = 1/39
• PROD B - LOW Class = 4/39
• etc

Anyone can help on this?

My QV file also attached.

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/7317.Test.zip:550:0]

Thanks a lot

[maneshkhottcpl · Accepted solution]

Hi,

As per my understanding of ur problem , the solution is to use Total/all

--- Count(Total USer) gives the count of all users i.e 39 based on the selection.

i.e if u select CLASS it gives count of all users belongs to the selected classes.

-- Count(ALL USer) gives u the count of all users regardless of selections.

so u can use --- Count(User)/Count(All User)

please try and if i m not correct reply me back to resolve ur issue.

Thanks

Manesh

[#3]

Yes. It works!

Thanks a lot