topic Automatically select value(s) that another object selects? in QlikView

Automatically select value(s) that another object selects?

harrywu1 — Wed, 25 Nov 2020 16:16:04 GMT

Hi, I am new to Qlikview, as the company I work for recently started to promote QlikView.

Let's say there's TABLE1 with values(A,B,C,D,E) and TABLE2 with values(A,B,C,D,E, and others), and they are in the same format.

When some values of Table1 are selected, I want the same values to be selected in Table2. No matter it's single selection or multiple.

I tried to use "Settings/Document Properties/Triggers" to set up a "OnSelect" action triggered by Table1's selection.

However I am struggling on how to compile the codes, because I want it to act dynamically, instead of manually setting up the connections by IF(TABLE1='A', TABLE2='A', IF(TABLE1='B', TABLE2='B', IF(...)))

Based on my limited programming experience (Excel VBA), my logics led me this way: Have a variable to store the selected value(s) of TABLE1. And, TABLE2 will be selected accoding to this variable. But I feel this is going to complicate the problem...

訊息由此人編輯：Harry Wu

Re: Automatically select value(s) that another object selects?

sunny_talwar — Mon, 25 Jun 2018 12:33:52 GMT

You might be able to use a trigger with a search string like this:

='(' & Concat(DISTINCT '"' & FieldNameTABLE1 & '"', '|') & ')'

Re: Automatically select value(s) that another object selects?

harrywu1 — Tue, 26 Jun 2018 00:24:30 GMT

Thanks! This is just amazing! It works!

It looks like a string combination of TABLE1, and TABLE2 adopts this combined string to select automatically itself.

I will take some time to learn the used functions of "Concat" & "DISTINCT", to figure out how this works.

Thanks again!