How to make sales for example as ABCDEFGH analysis

Tue, 26 Mar 2013 14:20:01 GMT

Hi!

I have a straight table as below

Customer as dimension

Revenue (sum(Price)) as expression

% Revenue (sum(Price); checked Relative chart properties) as expression

Revenue cumulative (sum(Price); checked Full Accumulation chart properties) as expression

% Revenue cumulative (sum(Price) checked; Relative and Full Accumulation) as expression

Now I would like to make additional selection to user as ABCDEFGH clients.

I assume that below example would be calculated from % Revenue cumulative expression as comparison to top sales which is calculated from % Revenue expression

For example:

A clients 30 % from sales

B clients 20 % from sales

C clients 15 % from sales

D clients 15 % from sales

E clients 10 % from sales

F clients 5 % from sales

G clients 3 % from sales

H clients 2 % from sales

If user is selecting A clients then it would only show clients who are buying 30 % from whole sales (% Revenue cumulative)

If user is selecting B clients then it would only show clients who are buying 20 % from whole sales (% Revenue cumulative) NOT A,C,D,E,F,G,H clients

If user is selecting C clients then it would only show clients who are buying 15 % from whole sales (% Revenue cumulative) NOT A,B,D,E,F,G,H clients

Is it possible to create statistics like this?

Thank you very much in advance!

Re: How to make sales for example as ABCDEFGH analysis

Tue, 26 Mar 2013 14:35:42 GMT

Hi,

The best would you create a table with parallel sorting by date customer, because every day the customer classification can change.

By Rebeca

topic How to make sales for example as ABCDEFGH analysis in QlikView

How to make sales for example as ABCDEFGH analysis

Re: How to make sales for example as ABCDEFGH analysis