topic get multiple selected values for SET ANALYSIS in QlikView

get multiple selected values for SET ANALYSIS

Mon, 31 May 2010 11:02:53 GMT

Hi,

Does anyone know how to include multiple selected values for set analysis?

i came up with the following set analysis formula, but only allowed to select one value at a time.

when i select 1 product, amount is correct, it shows 0 when i selected multiple.

= ( Sum ( {$<Product={'$(= Product)'}>} (AMOUNT)) )

get multiple selected values for SET ANALYSIS

Mon, 31 May 2010 11:34:45 GMT

Hi! Nicksatch

Try using this expresssion

= Sum ( {$<Product=>} AMOUNT)

get multiple selected values for SET ANALYSIS

Mon, 31 May 2010 11:45:37 GMT

Nick,

another approach is:

Sum( {<SalespersonName={"$(=concat(distinct SalespersonName,'","'))"}>} LineSalesAmount)

Good luck!

Rainer

get multiple selected values for SET ANALYSIS

Mon, 31 May 2010 12:31:32 GMT

Rahul, that formula actually returns all the values in product for you. it doesn't correspond to any selection user make.

Rainer's approach is what i used.

I'm still very amazed at how SET analysis works. I thought i'd need to include all the selection fields into the set formula, in fact, i just need to pick one, n QV will do the rest for me. I find it very strange, but, i guess it will take a while for me to accept this fact. 🙂