depending two listboxes

[#1]

Dear experts,

I have included several excel-sheets to QlikView. In Script i connected all tables, but I don't get connection between these two lower tables.

Now I have a report with actuall- and plan-values. These values are divided into categories (EM-M...).

These Listboxes (Art and ArtPlanzahlen) have several values / categories.

Now I want to select value in "Art", and that the selected value automaticly selected in "ArtPlanzahlen".

Value from Listbox "Art" I can get without problem: "GetFieldSelections(Art)"

My problem, that I don't know where I can insert it in "ArtPlanzahlen".

Where / How I can connect this values without "script / tablestructure" ?

[#2]

The solution of this problem was:

Properties --> Documentproperties --> Trigger

Here I could define the value for my second table.

[maxgro · Accepted solution]

add a field event trigger (menù --> settings --> document properties --> triggers) on the field Art

OnSelect               Add Action

Field                      ArtPlanzahlen

Search String      =if(GetSelectedCount(Art)>0,  '("' & concat(DISTINCT Art, '"|"') & '")' ,''  )