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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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