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: 
Ashwini_B
Contributor
Contributor

how to Display customized 3 fields and others field should fall under 'Others' in pie chart

I need only 3 field to be visible in the Pie chart and the rest of the fields should fall under 'Others' irrespective of the values. only NDA, Contract and price list should be  displayed in the Pie chart and rest of the field in 'Others'. (refer below image )

Please help to achieve this.

 

Ashwini_B_0-1680177693685.png

 

1 Reply
Or
MVP
MVP

If you want to display the top 3 (and Others), you can use Dimension Limit.

If you want it to be hard-coded to those values (and others) you need to create either a field (in script) or a calculated dimension along the lines of (If(Match([Contract Type],'Value1', 'Value2', 'Value3'),[Contract Type],'Other')