topic average, count class Problem in QlikView

average, count class Problem

Thu, 28 May 2009 16:59:01 GMT

Hi,

I have a table custumers. For every customer I have several kpis, e.g.
Customer KPI
=========================
Customer_1: 2
Customer_1: 2
Customer_2: 4
Customer_2: 2
Customer_2: 6
Customer_3: 2
Customer_3: 2
customer_4: 11

I'd like to calculate the average of every customer: e.g. Customer_1: 2, Customer_2: 4, Customer_3: 2, Customer_4: 11

So far no problem. Now I'd like to create a class of average KPIs e.g. 1-5, 5-10, 10-15,..

My Barchart should show the number of customers with the classes. eg.

class: 1 - 5 contains Customer 1,2,3 because they have the average kpi 2,4, 2. -> Barchart should show for Class 1-5 the value 3 (3 customers).
class: 5 - 10 -> 0
class: 10 - 15 -> 1

Any chance with aggr()?

Thanks in advance.

Regards

average, count class Problem

Thu, 28 May 2009 18:32:39 GMT

Hi Aloah,

see the attached example.

Rainer

average, count class Problem

manishkumar75 — Thu, 28 May 2009 18:55:59 GMT

Hi,

Plz see the attached example.

- Manish

average, count class Problem

Fri, 29 May 2009 16:37:08 GMT

Hi,

thanks. This works so far.

Now I also have a datefield:

Customer KPI Date
=========================
Customer_1: 2 01.01.2008
Customer_1: 2 01.01.2009
Customer_2: 4 02.01.2008
Customer_2: 4 02.01.2009
Customer_2: 6 03.01.2009
Customer_3: 2 01.01.2009
Customer_3: 2 02.01.2009
customer_4: 11 01.01.2009

The Average for customer_2 is in 2008: in 2009: 5 and Overall 4,6

The Bar Chart should show the average dynamic. Is this possible?