why Concat() -Function no need for double quotes in set expression

[Applicable88]

Hello,

someone here just helped me out with the return of a straight table where I needed a calculated dimension to filter only the very top and the very bottom dataset of a value:

=Aggr(Only({<ActionNo. = {$(=Concat(Aggr(Min(ActionNo.),QueueNo.),',')),$(=Concat(Aggr(Max(ActionNo.),QueueNo.),','))}>}ActionNo.), ActionNo., QueueNo.)

What strikes me is that, why the concat() function doesnt need a double quote to initiate a search?  Does not a the dollar sign expansion within the curvy bracket of a set expression always need to be initiated into a search?

Hope someone can explain to me.

Thank you very much. 

[tm_burgers · Accepted solution]

I believe it is because the resulting set expression is not searching the data set; it is looking for distinct values that your concat expressions are feeding the set expressing. 

when you are searching you are using >  or < or a wildcard; then you would need double quotes, but in your set expression the concat fields are being generated as a comma separated list of distinct values. 

[MayilVahanan · Accepted solution]

Hi @Applicable88 

$(=Concat(Aggr(Min(ActionNo.),QueueNo.),',') <-- Its concatenate the minimum of Action No based on QueueNo and we're not searching here. We're assigning the values. 

$() <-- its evaluates the values.