topic Use dimension value in set analysis in QlikView

Use dimension value in set analysis

Tue, 11 Dec 2012 16:41:09 GMT

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

Re: Use dimension value in set analysis

Tue, 11 Dec 2012 18:03:56 GMT

Hi,

sum (Amount)

does not work?

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

Re: Use dimension value in set analysis

Gysbert_Wassenaar — Tue, 11 Dec 2012 18:40:41 GMT

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.

Re: Use dimension value in set analysis

Thu, 13 Dec 2012 09:08:20 GMT

Hi,

SUM(amount) does not work.

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

Cheers

Re: Use dimension value in set analysis

Thu, 13 Dec 2012 09:11:20 GMT

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

Re: Use dimension value in set analysis

Thu, 13 Dec 2012 10:55:24 GMT

This is the double load version of it.

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

Cheers