Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

daniel_freitas
New Contributor

Concentration Histogram

Dear All,

I need to create a concentration histogram chart, which tells, by each supplier cluster, the percentage of the total number of product it has.

I have available the following table:

Supplier# Products
A200
B150
C105
D100
E90
F80
G70

I need to then cluster the suppliers due to its number of products. I mean: the first 1% suppliers (lets say only one in a total of 100 suppliers) is categorized as 'first 1%', the following falls in the 'from 1 to 20%' cluster and so on.

With so, I need to create the following chart:

distribution chart.PNG

Has someone eveer done something like this?