Skip to main content
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

How can I only show top trending category without Occurrence for particular month

Company            Aug 2022               Occurrence 

A                                 textile                           4

B                                 Steel                             5

C                                  Iron                              3

D                                  Copper                       5  


Hello folks, This is an really urgent requirement. I want to show only Aug 2002  column which is showing max occurring categories and want to remove Occurrence. But when removing occurrence all categories comes in category column as textile comes 4 times, steel comes 5 times. However I only want to show top categories that occurs multiple time. Tried from the load editor but load editor doesn't support aggr() function. Can anyone help with this weather it's possible to show in table chart or not ?

0 Replies