topic Re: Limit a boxplot for top n categories by measures in App Development https://community.qlik.com/t5/App-Development/Limit-a-boxplot-for-top-n-categories-by-measures/m-p/2503456#M103612 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/174995">@JandreKillianRIC</a>&nbsp; Hello, here's the data. I hope it's extensive, let me know if you need anythign more! Thanks again for looking into it</P> Wed, 29 Jan 2025 08:31:45 GMT alespooletto 2025-01-29T08:31:45Z Limit a boxplot for top n categories by measures https://community.qlik.com/t5/App-Development/Limit-a-boxplot-for-top-n-categories-by-measures/m-p/2503453#M103611 <P>I have this excerpt of data that can be used to create a boxplot:&nbsp;</P> <LI-CODE lang="markup">// Caricamento della tabella del Boxplot BoxplotData: LOAD Categorie, [First whisker], [Box start], [Center line], [Box end], [Last whisker] INLINE [ Categorie, First whisker, Box start, Center line, Box end, Last whisker "Tablet AGV", 929.266666666667, 929.266666666667, 929.26667, 929.266666666667, 929.266666666667 "Smartcard", 748.366666666667, 748.366666666667, 748.36667, 748.366666666667, 748.366666666667 "Notebook", 720.583333333333, 720.583333333333, 720.58333, 720.583333333333, 720.583333333333 "Office", 27.9833333333333, 217.2609443788, 674.21667, 1131.1726388955, 1320.45 "Cuffie", 303.9, 303.9, 303.9, 303.9, 303.9 "iPad", 167.533333333333, 167.533333333333, 167.53333, 167.533333333333, 167.533333333333 ]; // Caricamento della tabella con le Durate Totali DurataTicket: LOAD Risorsa, Categorie, Durata_Totale INLINE [ Risorsa, Categorie, Durata_Totale "Mor", "Posta", 446.55 "Riz", "iPhone", 1278.5 "Riz", "Cuffie", 303.9 "Riz", "Docking Station", 100.8666667 "Riz", "Monitor", 76.6 "Riz", "Notebook", 720.5833333 "Riz", "Smartcard", 748.3666667 "Riz", "Carta inceppata", 0.166666667 "Riz", "Non stampa", 2.916666667 "Riz", "Tablet AGV", 929.2666667 "Riz", "Tablet Muletti", 25.3 "Riz", "CRM", 53.48333333 "Riz", "DriveTools", 51.71666667 "Riz", "Internet", 95.38333333 "Riz", "Jabber", 2.55 "Riz", "Office", 1320.45 "Riz", "Posta", 2591.683333 "Riz", "SAP", 1078.266667 "Riz", "Online Support", 99.68333333 "Riz", "iPad", 167.5333333 "Vit", "Office", 27.98333333 "Nes", "Controllo accessi", 69.85 ]; </LI-CODE> <P>What I would like to receive is a boxplot graph that has only the top 3 boxes with the highest number of time spent for them ,and put the rest in an averaged out boxplot on its own.&nbsp;</P> <P>&nbsp;</P> <P>Similar to this graph, where the 5 bars represent the top categories, and an Others bar represents the average of the remaining categories:&nbsp;<BR /><BR /></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="alespooletto_0-1738139068174.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/177007iD7A971949FEF8E73/image-size/medium?v=v2&amp;px=400" role="button" title="alespooletto_0-1738139068174.png" alt="alespooletto_0-1738139068174.png" /></span></P> <P>&nbsp;</P> Wed, 29 Jan 2025 08:30:36 GMT https://community.qlik.com/t5/App-Development/Limit-a-boxplot-for-top-n-categories-by-measures/m-p/2503453#M103611 alespooletto 2025-01-29T08:30:36Z Re: Limit a boxplot for top n categories by measures https://community.qlik.com/t5/App-Development/Limit-a-boxplot-for-top-n-categories-by-measures/m-p/2503456#M103612 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/174995">@JandreKillianRIC</a>&nbsp; Hello, here's the data. I hope it's extensive, let me know if you need anythign more! Thanks again for looking into it</P> Wed, 29 Jan 2025 08:31:45 GMT https://community.qlik.com/t5/App-Development/Limit-a-boxplot-for-top-n-categories-by-measures/m-p/2503456#M103612 alespooletto 2025-01-29T08:31:45Z