Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
berryandcherry6
Creator II
Creator II

Display of Grouping of not required data to other in Pie Chart

Hi,

i have below data

mobileDeviceModelsum(MobileUsers)
(not set)213
0P6B13023
0PAJ51
0PCV16
0PCV2205
0PJA11
0PJA22
0PM925
0PM9121
2PQ932
2PS641
2PST22

Here i need to show pie chart for Models whose value is greater than 1.and other which are <= 3 should be shown as other in piechart with legend. How could i do this?

1 Solution

Accepted Solutions
Anonymous
Not applicable

=if(

Aggr((Sum(MobileUsers)), mobileDeviceModel)<=3,

mobileDeviceModel,

'Others'

)

View solution in original post

3 Replies
Anonymous
Not applicable

I do not see anything     <= 1  ??

berryandcherry6
Creator II
Creator II
Author

Hi allu,

Those are dynamic values. If in case if there are values like '-' , null those are all should be grouped to other.

Anonymous
Not applicable

=if(

Aggr((Sum(MobileUsers)), mobileDeviceModel)<=3,

mobileDeviceModel,

'Others'

)