Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
aarav021
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