topic How to calculate the % of a sub-group within a group in QlikView

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

Fri, 11 Feb 2011 04:23:17 GMT

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.

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 — Fri, 11 Feb 2011 05:02:28 GMT

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

Fri, 11 Feb 2011 08:21:01 GMT

Yes. It works!

Thanks a lot