Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

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: 
swatitomar
Contributor III
Contributor III

Agg with Set analysis

Hi Team , 

I'm trying create the share% on the basis of 2 Dimension in Pivot Table but not getting correct result as needed .

2 Group are there , now i want the share % individually on group basis.

 
 CountShare%
Group 12705452100%
Only Customer247552991.5%
Only Partner1423335.3%
Only Vendor875903.2%
Group 2154821100%
 Customer & Partner11284272.9%
Vendor & Partner17951.2%
Customer & Vendor4018426%
 
 
 
 

 

 

Labels (2)
1 Solution

Accepted Solutions
Kushal_Chawda

assuming you have count expression as  count(ID) 

you can try below expression for Share%

=count(ID)/count(total<Group>ID)

View solution in original post

2 Replies
Kushal_Chawda

assuming you have count expression as  count(ID) 

you can try below expression for Share%

=count(ID)/count(total<Group>ID)

swatitomar
Contributor III
Contributor III
Author

Thank you!