topic Re: Select values in a field based on Selections on the same field in QlikView

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

qlikwiz123 — Sat, 16 Nov 2024 00:09:48 GMT

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 — Tue, 11 Aug 2020 17:55:58 GMT

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 — Tue, 11 Aug 2020 23:39:33 GMT

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

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