Select values in a field based on Selections on the same field

[qlikwiz123]

LOCAL

SALES

CORPORATE

MARKETING

EVENTS

MAINTENANCE

MEDICAL

PUBLICITY

This is my Field - LOCAL

Whenever I select any value, it should also select 'MEDICAL' and 'PUBLICITY' values.

Example- Selecting 'SALES' should select 'SALES','MEDICAL', and 'PUBLICITY'.

Selecting 'MAINTENANCE should select MAINTENANCE, MEDICAL and PUBLICITY

[lironbaram · Accepted solution]

hi 

go to document properties 

and triggers there you'll go to the second section , field action 

select the local field and than click on the button under on select 

add 2 actions type toggle select

[Saravanan_Desingh · Accepted solution]

In addition to @lironbaram  idea, use the below expression for the Field LOCAL in the Trigger.

='('&GetFieldSelections(LOCAL)& ' | "MEDICAL" | "PUBLICITY")'