Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming Aug. 9: New Simplified Authoring for Qlik Sense SaaS – For Details, CLICK HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

Hi all,

error loading image

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

1 Solution

Accepted Solutions
maneshkhottcpl
Partner - Creator III
Partner - Creator III

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

View solution in original post

2 Replies
maneshkhottcpl
Partner - Creator III
Partner - Creator III

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

Not applicable
Author

Yes. It works!

Thanks a lot