Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
theboss-123
Creator II
Creator II

Percentage of total "set analysis"

hello using the formula im finally got the top 10 values in pivot table 

SUM({<PARTNER= {"=Rank(SUM([Quantité Facturé]),4)<=10"}>}[Quantité Facturé])

 

im looking to show another column  for "percentage of total" like this

PARTNER TOP 10   
ENVASES  2 069 064,00 3%
EVIOSYS  34 604 518,00 44%
EXPRIM  1 136 060,00 1%
GHARB 880 868,00 1%
IMPRIMEPEL 4 791 808,85 6%
MASSI 17 488 452,00 22%
TRIVIUM P 8 438 174,25 11%
TRIVIUM B 1 504 224,00 2%
TRIVIUM C 6 766 020,00 9%
TRIVIUM D 1 821 924,00 2%
Total 79 501 113,10 100%
Labels (1)
1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

I think  it would just be:

Column(1) / SUM({<PARTNER= {"=Rank(SUM([Quantité Facturé]),4)<=10"}>} TOTAL [Quantité Facturé])

-Rob

View solution in original post

2 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

I think  it would just be:

Column(1) / SUM({<PARTNER= {"=Rank(SUM([Quantité Facturé]),4)<=10"}>} TOTAL [Quantité Facturé])

-Rob

theboss-123
Creator II
Creator II
Author

Thanks Bob that worked