if in set expressions

[gandalfgray]

I want to use set analysis to make selections in one field ("ActualField") using another field ("SelectorField").

so this does the trick, right:

Count({<ActualField=SelectorField>} DISTINCT ID)

But not completely,

This works as expected for all cases, except when there is no selection made in SelectorField,

when the above does not return a value.

I found a solution for that:

if(GetSelectedCount(SelectorField)>0,

    Count({<ActualField=SelectorField>} DISTINCT ID),

    Count({<ActualField=} DISTINCT ID)

)

But is there a syntax to get the "if" inside the set expression,

I tried like this but it does not work:

Count({$<ActualField={$(=if(getselectedcount(SelectorField)>0,SelectorField,ActualField))}>} DISTINCT ID))

[erichshiino · Accepted solution]

Try this:

Count({<ActualField=p(SelectorField)>} DISTINCT ID)

This should get all possible values in SelectorField and use as values for ActualField

Hope it helps,

Erich

[gandalfgray]

Excellent Erich!

I knew there was an elegant way to solve this.

Thanks!

[perumal_41]

please explain breifly .

Count({<ActualField=p(SelectorField)>} DISTINCT ID)