topic Re: Help to build ABC Chart (Pareto) in App Development

Help to build ABC Chart (Pareto)

Nemo1 — Fri, 15 Nov 2024 21:03:36 GMT

So my dream is to build the graph below... I will explain further because my drawing kinda sucks. 🙂

I want to build a graph, paretto style, that classifies CITIES according to their %Acc Sales. The 10% of cities where the most sales where made should be classifies as 1, the other 20% as 2, and then the rest as 3:

I have two problems:

1- in the x axis I can only display the cities sorted from the ones where the biggest sale where made to the ones where the lowest sale was amde. (I could sorted according to their sales in a descending order)

2- I do now know how to add lines to the graph that mark where the "1" cities start in the x axis, where the "2" cities start and the "3"... i would like to mark that and what % of sales they made.

what I managed to do:

what I want to do:

I hope that was clear.. it is not easy to explain. I am not good at explaining myself, I will create another question soon and I will ask chatgpt to help me explain myself better.. in case you wanna check the other question out, i will leave the link below..

thanks everyone 😄

Re: Help to build ABC Chart (Pareto)

Nemo1 — Mon, 19 Feb 2024 08:28:55 GMT

here is explained by chatgpt : Challenges I am having when creating a Pareto grap... - Qlik Community - 2420561

Re: Help to build ABC Chart (Pareto)

brunobertels — Mon, 19 Feb 2024 08:43:17 GMT

here a usefull like :

https://community.qlik.com/t5/Design/Recipe-for-an-ABC-Analysis/ba-p/1472867

Re: Help to build ABC Chart (Pareto)

theoat — Mon, 19 Feb 2024 08:56:19 GMT

Hello, you can watch this article by @Patric_Nordstrom. The first visualization presented is what you're looking for.

24 days Season 2 - Qlik Community - 2019797

Kind regards,
Théo ATRAGIE.

Re: Help to build ABC Chart (Pareto)

Nemo1 — Mon, 19 Feb 2024 12:05:30 GMT

thanks! that is what I was looking for!