topic Count customer with cumulative amount in QlikView

Count customer with cumulative amount

tgumbing — Thu, 18 May 2017 09:09:44 GMT

Hi,

How to calculate the number of customer which make 80% of the total amount.

How to calculate the number of customer which make between 80 and 95% of the annual amount.

...

With the result in a text object.

The Data : The Customers are classified by amount

Thanks

Thomas

Re: Count customer with cumulative amount

goro2010 — Thu, 18 May 2017 15:47:05 GMT

Good Day, if you have 2 expressions in Sum, then you can make another expression to say coloumb(2)/coloumb(1), then you can just add to your color filter to be green anything above 0.8 as a numeric number.

Re: Count customer with cumulative amount

tgumbing — Fri, 19 May 2017 06:59:52 GMT

Hi,

The Cummulative column not exist in my final project. it's only for my example.

Re: Count customer with cumulative amount

tgumbing — Fri, 19 May 2017 07:15:26 GMT

I want this in a text object:

3 Customers how have 80% of the total amount.

1 Customers between 80 and 95% of the annual amount.

4 Customers with less than 95% of the annual amount.

1 with 0 annual amount.

Re: Count customer with cumulative amount

jonathandienst — Fri, 19 May 2017 07:19:42 GMT

These might help you

Recipe for a Pareto Analysis

Recipe for a Pareto Analysis – Revisited

Re: Count customer with cumulative amount

Frank_Hartmann — Fri, 19 May 2017 08:26:39 GMT

hi,

have a look at the attached sample

hope this helps

Re: Count customer with cumulative amount

tgumbing — Wed, 24 May 2017 13:15:42 GMT

Hi Frank,

that's right. But if the data is not sorted at loading ?

How to add sorting to expression.

Re: Count customer with cumulative amount

Frank_Hartmann — Wed, 24 May 2017 19:49:43 GMT

then you will have to follow these steps in script:

1. Make a resident load of your Inline table with an order by statement.

2. Load this resident table into a qvd file. Drop the other tables.

3. Load the qvd file.

see attached sample.

hope this helps