topic Re: set analysis expression in QlikView

set analysis expression

Prabhu1204 — Sat, 16 Nov 2024 01:08:47 GMT

Could anyone explain the below set analysis expression.

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

Re: set analysis expression

marcus_sommer — Tue, 03 Mar 2020 12:20:47 GMT

$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

Re: set analysis expression

Brett_Bleess — Wed, 01 Apr 2020 19:51:02 GMT

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