conditional aggr() function use

gerrycastellino — Tue, 26 May 2015 23:42:51 GMT

Here's my situation:

I have a list box "fieldA"

I'm trying to implement a conditional aggr() function for this list box, which will be driven if a dimension from fieldB is selected or not.

Basically, I'm trying to get a statement working as follows:

=pick(if(not(isnull(only({[State1]} fieldB))),1,0)+1,

aggr(only({<ASSET_CLASS=P({State2}) * P({State3})>} fieldA), fieldA), // performs a union from states 2,3

aggr(only({<ASSET_CLASS=P({State4}) * P({State5)>} fieldA), fieldA)) // performs a union from states 4,5

The list box does not seem to be supporting this construct, not sure how I can re-arrange this.

Gerry.

topic conditional aggr() function use in QlikView