topic Excluding Selections with Set Analysis in QlikView

Excluding Selections with Set Analysis

Mon, 07 Mar 2011 09:30:01 GMT

Im trying to exclude a couple of selections in my chart expression.

What i currently have is the following, it works, but i dont know how to combine it to force the expression to ignore multiple selections

sum({<coldroom=>} noofbins)

sum({<packed=>} noofbins)

sum({<consigned=> noofbins)

Any help on combining these into one expression? thanx in advance

Miguel_Angel_Baeyens — Mon, 07 Mar 2011 09:34:36 GMT

Hello,

You almost have it:

Sum({< coldroom =, packed =, consigned = >} noofbins)

Hope that helps.

Mon, 07 Mar 2011 10:03:21 GMT

excellent, exactly what i looked for thanx