set analysis question

[#1]

Hi there.

Let's say I have two list boxes: product group, and product.

product group product

group1 product1

group1 product 2

group2 product3

group2 product4 and so on.

What I am trying to do is this:

If I select group1, I want to show product1, product 2 sales, each as percent of group1.

So if proudct1 sale is 100, and product sale is 400, then they would show as 20%, 80% respectively. This part is pretty easy. I can have something like sum(sales)/ sum( total [product group] sales) or something to that effect.

However, I also want the calculation to work when the user selects the products, not proudct group. So for example, if the user select product2 (and nothing selected in product group), I want the chart to show 80%.

What would be the best way to do this?

[#2]

Something like this:

Sum(Sales)/Sum({1} TOTAL <Group> Sales)

The denominator will get you the total sales per group regardless of selection. QlikView's normal selection functionality should take care of the rest.

[#3]

I tried it and it does not work. How does the expression know which Group to total over, if I am selecting only from the Product list?

[#4]

I assumed you had a chart with Groups listed. How would you know which Group it should total over?

[#5]

Yeah, that is the tricky part I was trying to achieve. What I was trying to figure out how to achieve this if the user select only the product, not the group. I was trying to come up with a set analysis which would figure out which group to sum over, because there is a data relationship between the product and the product group.

[#6]

Okay I tried it again and somehow it works, even when I do not have the product group selected..... Thanks.