Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Need help with dividing column with column total

I have a column that is totals up how many items in a classification

=NUM(count(DISTINCT(ItemNumber)))

That works great, but I want to divide the row total for the item classification with the column total for the items numbers.

For example

Item Class     Number of items Percentage of Items

                         50                         100%

Pink                   10                         20%

Blue                   20                         40%

Green               20                           40%

I need the forumla for the percentage of items

1 Solution

Accepted Solutions
Not applicable
Author

percentage

count(Number of items)/cOUNT(TOTAL Number of items )

View solution in original post

1 Reply
Not applicable
Author

percentage

count(Number of items)/cOUNT(TOTAL Number of items )