set analysis expression

[Prabhu1204]

Could anyone explain the below set analysis expression.

{$<$(=concat({<$Table-={"Department","Department Group"}>} '[' & $Field & ']=',','))>}

[marcus_sommer]

$Table and $Field are system-fields containing the table/field-names of your loaded datamodel. The concat() within the $-sign expansion creates now a field-listing of all tables unless the specified department-tables in the way of:

[Field1]=, [Field2]=

which is then used to ignore any selection in all listed fields for the calculation which contains this set analysis.

- Marcus

[Brett_Bleess]

If Marcus' post helped you with what you needed, please be sure to close out your post by using the Accept as Solution button on his post, as this gives him credit for the help and lets other Members know it was what you needed.  

I am also providing the following Design Blog link that may help you be able to sort things out on your own too:

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

Regards,
Brett