Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Use dimension value in set analysis

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

5 Replies
Not applicable
Author

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.


talk is cheap, supply exceeds demand
Not applicable
Author

Hi,

SUM(amount) does not work.

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

Cheers

Not applicable
Author

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

Not applicable
Author

This is the double load version of it.

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

Cheers