Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
fredericmante
Partner
Partner

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

Fred

25 Replies
fheidenstecker
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

http://www.dhl-discoverlogistics.com/dhl/logistikkurs/img/de/chapter_04/4.3.3_Selektive_Lagerhaltung...

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,

Fabian

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.

Thanks

Gerard

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.

Thanks.

Marco.

diego_alegre_nu
Contributor II
Contributor II

Hi John,

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

THNX,

yblake
Partner
Partner

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

diego_alegre_nu
Contributor II
Contributor II

Thank you Yves! Great!