count occurence of each unique value

[#1]

HI,

I'm having trouble with calculating the following data.

There is a table with sales information. Each row represents one sale of one product. there is one row that contains the product name that is sold. (Row: product)

I want to know how many of each product is sold over the selected period.

I used to do this with MSSQL like this:

select

     product,

     count(*) as amount

from salestable

group by product.

With the results I want to make a bar graph that stacks the amount of each product like this:

How can I do this in Qlikview with the greatest possible flexibility? I don't want to count each product separately, there can be over a 200 different products so I want to do this dynamical.

[#2]

Check the Attachment.

[#3]

Thanks, this helps me a lot!