Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Check the Attachment.
Thanks, this helps me a lot!