topic CREATE DIMENSION from =Aggr(Count(Distinct Year),Customer) in QlikView

CREATE DIMENSION from =Aggr(Count(Distinct Year),Customer)

Fri, 16 Apr 2010 14:40:24 GMT

=Aggr(Count(Distinct Year),Customer)

From this expression, I've created buckets where you have customers with 0,1,2,3, years of business.

Now I would like to create a pie chart with these buckets with the dimension being the distinct years. How would I go about doing this? Thank y ou in advance.

CREATE DIMENSION from =Aggr(Count(Distinct Year),Customer)

d_pranskus — Fri, 16 Apr 2010 16:43:20 GMT

Could you explain a little bit more what you ar trying to achieve.

Cheers

Darius

CREATE DIMENSION from =Aggr(Count(Distinct Year),Customer)

Fri, 16 Apr 2010 17:03:02 GMT

Apologies for the ambiguity.

I have a list of clients and sales over 3 years and 10 sales divisions.

The end result I want is to create a chart/pie chart that shows:

sales of clients who have dealt with all 10 divisions,
sales of clients who have dealth with 9 divisions,
sales of clients who have dealth with 8 divisions,
sales of clients who have dealth with 7 divisions etc....

I used the aggr(count(distinct division), client) to create the appropriate buckets in a LIST BOX but i'd now like to create a new field named 'Clients and number of divisions'. This would presumably allow me to create a pie chart with each slice being 10,9,8,7...etc.

If I write this into the script, I'm wondering what the syntax would be or if there is a better solution that would be great.

Thank you.

CREATE DIMENSION from =Aggr(Count(Distinct Year),Customer)

Fri, 16 Apr 2010 18:13:49 GMT

Hi henrynoh,

view atteched file.

Alex

CREATE DIMENSION from =Aggr(Count(Distinct Year),Customer)

Fri, 16 Apr 2010 18:40:15 GMT

Thank you! This is precisely what I was looking for.