Use dimension value in set analysis

[#1]

Hi,

I am stuck on a problem that is drivning me crazy!

I need to calculate the associated sales for all products.

(sum of sales for all customers who bought the product in the dimension column)

Attached is a Qlikview with data and some test that don't work. (tried several others also)

Anyone know how to do this. I rather not load the sales table twice.

Cheers

Martin

[#2]

Hi,

sum (Amount)

does not work?

if you use two dimensions, customer and product, does not work?

[Gysbert_Wassenaar]

You can't use set analysis expressions for that. Set analysis expression calculates set once for the entire chart, not per row. You want different sets for the different rows. You'll probably have to use an if statement. See attached qvw.

[#4]

Hi,

SUM(amount) does not work.

I am looking for the sums of all receipts containing the dimension product.

Cheers

[#5]

Hi,

The problem is that there will be lots and lots of products, so the IF-aproach is not doable.

I guess i have to read the transaction table twice them.

Cheers

martin

[#6]

This is the double load version of it.

Still think it's a shame to load same data twice...

Cheers