Skip to main content
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
Showing results for 
Search instead for 
Did you mean: 
Partner - Contributor III
Partner - Contributor III

number of customer who makes 80% of turnover

hi all,

i need your help
I would like to display in a text object, the number of customer who makes 80% of turnover.

Thanks in advance for your help


25 Replies
Creator II
Creator II

Hi there,

i had a look at your examples for the pareto analysis. These are some very usefull examples. I just wante to ask if any of you has an idea how to display this kind of information in a chart?

I want it to look something like this example graph

The x axis should show the percenteage of customers cumulating up to 100 %, the y axis should show cumulated revenue up to 100 %. I am not even sure what chart to use, i am wondering if i need a matrix chart, but with lines and not dots???

Thanx for suggestions,


Not applicable

Hi There,

In John's qvw file, the figure that is shown is given for the table sorted by weeks.

Does anyone know how to report the figure when the sorting parameter is on the Amount field (descending or ascending).

The goal is to report the value in a text field that would state:

i.e 80% of the aggregated 'field' Amount is concentrated in 4 'weeks' regardless when the weeks happen.



Not applicable

First of all thanks to all usefull approach,

I'm having the same problem with counting occurence in a textbox and i would like to know if someone have come up with a solution to the sorting problem.



Partner - Contributor II
Partner - Contributor II

Hi John,

Any solution after so much time. I am stuck right in the same point.


Partner - Creator II
Partner - Creator II

After so much time, the solution came from R&D : The sortable Aggr function is finally here!

Partner - Contributor II
Partner - Contributor II

Thank you Yves! Great!