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

Is there a way to create a summary table showing information reflected in a larger table, 2 different objects?

I have a Pivot Table with calculations to identify product (A,B,C) rankings.

I would like to have a summary table saying how many products have A assigned, B assigned,...and so on. Example below.

Is this possible?

LARGE TABLE

Style_DescPH3 - GenderPH5 - ClassificationTimes AveRanking
Product 27WOMENSSS Tee3.8A+
Product 28WOMENSSS Tee3.8A+
Product 29WOMENSSS Tee3.3A+
Product 30WOMENSSS Tee3.1A+
Product 31WOMENSSS Tee2.9A
Product 32WOMENSSS Tee2.8A
Product 33WOMENSSS Tee2.7A
Product 34WOMENSSS Tee2.7A
Product 35WOMENSSS Tee2.5A
Product 36WOMENSSS Tee2.4A
Product 37WOMENSSS Tee2.4A
Product 38WOMENSSS Tee2.4A
Product 39WOMENSSS Tee2.3A
Product 40WOMENSSS Tee2.2A
Product 41WOMENSSS Tee2.1A
Product 42WOMENSSS Tee1.9B
Product 43WOMENSSS Tee1.9B
Product 44WOMENSSS Tee1.5B
Product 45WOMENSSS Tee1.5B
Product 46WOMENSSS Tee1.2B
Product 47WOMENSSS Tee1.2B
Product 48WOMENSSS Tee1.2B
Product 49WOMENSSS Tee1.0B
Product 50WOMENSSS Tee1.0B
Product 51WOMENSSS Tee0.9C
Product 52WOMENSSS Tee0.9C
Product 53WOMENSSS Tee0.9C
Product 54WOMENSSS Tee0.9C
Product 62WOMENSSS Tee0.7C
Product 63WOMENSSS Tee0.7C
Product 64WOMENSSS Tee0.7C
Product 65WOMENSSS Tee0.7C
Product 66WOMENSSS Tee0.6C
Product 67WOMENSSS Tee0.6C
Product 68WOMENSSS Tee0.6C
Product 69WOMENSSS Tee0.5C
Product 70WOMENSSS Tee0.5D
Product 71WOMENSSS Tee0.4D
Product 72WOMENSSS Tee0.4D
Product 73WOMENSSS Tee0.4D
Product 74WOMENSSS Tee0.4D
Product 75WOMENSSS Tee0.4D

SUMMARY TABLE DESIRED

Rank     Product Count

A+          4

A          11

B     ...    

C

D

2 Replies
Not applicable
Author

Please find the attached file.

Not applicable
Author

The Rank is a calculated field that changes based on the Times Average value. In the example it looks like the Rank is a static value. Is a summary table still possible?