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

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to Calculate %age contribution of each Bucket?

I have just created a table which looks like below. This table gives me count of items in each bucket for each person...

       

bucketCreated ByadminMadhukarNaveenPremanshpremanshTaufeeq
60-300 555329415714609
300-420 -165128726156
0-60 --1---
420-540 --1---

Now want i want is %age contribution of each person in each bucket; i.e. a table which should look like below.

Please let me know how can i create below table in qV

      

Bucket Wise %
BucketMadhukarNaveenPremanshTaufeeqTotal
60-300100%99%100%98%99%
300-4200%1%0%2%1%
420-5400%0%0%0%0%
540-6600%0%0%0%0%
660-7200%0%0%0%0%
720 & Above0%0%0%0%0%
Total100%100%100%100%100%
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

count(Bucket)/count(TOTAL <"Dimension field"> bucket)

View solution in original post

1 Reply
Anonymous
Not applicable
Author

count(Bucket)/count(TOTAL <"Dimension field"> bucket)