Create a graph of frequency of occurence

[#1]

Hello all,

I've started learning Qlikview on my own just a few days ago. Here's the problem I'm facing; hope someone can help as I've already spent a LONG time trying to figure this out.

I have a data file with the 2 following fields among others:

Purchase ID Customer ID Status

------------------ ------------------ ---------

A392783      123              Active

A323423       555             Active

A392234       123             Cancelled

A392566       195              Active

I want to create a bar graph that shows

Have purchased at least n times in X-Axis, from 1 to 10

No. of customers in Y-Axis

AtLeastNPurchases Count          Percentage

------------------            ------------------ ---------

1                            16653           100%

2                            2000             12%

.

.

.

10                          195                1%

Can someone explain to me how I can set this up in Qlikview, please note that I only have very limited knowledge of QV, so please try to be as specific as possible...

Thanks!

[#2]

Oh i see, in your example, you had 3 rows in the aggregated table 1,3,4, that's why 3 works for below. In my data, there's 18 rows, that's why i needed n=18 as a minimum to get it to work. Anything wrong with putting a large value like 100? Just slows down the processing if there's large amount of data i guess?