Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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" ?
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, '"|"') & '")' ,'' )
The solution of this problem was:
Properties --> Documentproperties --> Trigger
Here I could define the value for my second table.
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, '"|"') & '")' ,'' )