Pie Chart to Show Top N and the Rest

[jagdishbr]

Hi, I'm new to Qlik Sense and have been working on migration project for weeks.

I'm aiming to calculate the FY23 sales sum for the top 5 clients by profit, labelling them as "Top 5," and group the remaining clients as "Others/Rest of Clients" to display in a pie chart.

Is there a way to achieve to this requirement. Please help 

Name	Type	Sales	Cost	Profit		Sales	Cost	Profit
		FY23	FY23	FY23		FY22	FY22	FY22
Nissan	D	749215	149843	599372		613526	184058	429468
Lexus	A	722517	144503	578014		250148	75044	175104
Aston Martin	S	609902	60990	548912		749215	149843	599372
Audi	D	539708	53971	485737		267269	80181	187088
Oldsmobile	S	537179	53718	483461		406935	40694	366242
Dodge	N	603812	120762	483050		269429	80829	188600
Mercedes-Benz	S	546320	109264	437056		272302	81691	190611
Mitsubishi	D	613526	184058	429468		558831	167649	391182
Subaru	D	592722	177817	414905		268842	80653	188189
Hyundai	S	558831	167649	391182		533553	160066	373487
GMC	D	462284	92457	369827		324301	64860	259441
Lotus	N	406935	40694	366242		577426	57743	519683
Isuzu	S	455060	91012	364048		209997	41999	167998
Volkswagen	N	437055	87411	349644		279537	83861	195676
Honda	A	408589	122577	286012		609902	60990	548912
Mercury	N	288338	28834	259504		437055	87411	349644
Lincoln	A	324301	64860	259441		208856	41771	167085
Porsche	S	268097	26810	241287		537179	53718	483461
Chevrolet	D	279537	83861	195676		234414	70324	164090
Acura	D	269429	80829	188600		656743	131349	525394
Pontiac	N	250148	75044	175104		268097	26810	241287
Ford	S	208856	41771	167085		603812	120762	483050
BMW	S	234414	70324	164090		455060	91012	364048
Saturn	N	226710	68013	158697		722517	144503	578014

[lennart_mo]

Hi @jagdishbr,

no need to flag them in your script, the pie-chart comes with a built in option to limit the displayed amount of values for a dimension as well as all others.

After adding your dimension to the chart there should be inputs as to wether you'd like to limit the amount of values shown. You can select how many are displayed, if 'others' are displayed and what their label should be.

Hope this is what you're looking for!