topic depending two listboxes in QlikView

depending two listboxes

Tue, 09 Feb 2016 12:12:57 GMT

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" ?

Tue, 09 Feb 2016 15:57:14 GMT

The solution of this problem was:

Properties --> Documentproperties --> Trigger

Here I could define the value for my second table.

maxgro — Tue, 09 Feb 2016 21:17:14 GMT

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, '"|"') & '")' ,'' )