Skip to main content
Announcements
Applications are open for the 2024 Qlik Luminary Program. Apply by December 15 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!