Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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
Highlighted
Not applicable

Re: Use dimension value in set analysis

Hi,

sum (Amount)

does not work?

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

MVP & Luminary
MVP & Luminary

Re: Use dimension value in set analysis

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

Re: Use dimension value in set analysis

Hi,

SUM(amount) does not work.

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

Cheers

Not applicable

Re: Use dimension value in set analysis

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

Re: Use dimension value in set analysis

This is the double load version of it.

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

Cheers