Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Dimension limits - show the largest 10 but keep the largest in 'others'

Hi All,

First post on the community site for me, I have a straight table showing the largest 10 values and everything else grouped in others, the single dimension I have is called 'Brand', I'm trying to show the top 10 performing brands but there are also many unbranded entries which are marked with '#' , the cumulative value of these means that they are ranked Number 1. Is there a way to  move all entries where the Brand is '#' to be calculated under 'others'?

Many Thanks,

Hareesh

0 Replies