Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Getcurrentselection

I have loaded a table having two fields for ex:-

in field1data is a,b,c

in field 2 data is combination of abc i.e.

a

b

c

a,b,c

a,b

b,c

When i click on field1 for a i want in field2 only a shud be highlighted  not others same for b and c,but when i click on a,b,c from field1 then only 3 data from field 2 i.e. a,b,c shud be highlighted .

Kindly help with this

7 Replies

Re: Getcurrentselection

Which objects are involved?

Chart? Multibox?

Let me know

Re: Getcurrentselection

Add a select in field action to the OnSelect field trigger (on the Triggers tab of the Document Properties window). Use =concat(field1,',') as search string. See attached qvw.


talk is cheap, supply exceeds demand
Not applicable

Re: Getcurrentselection

where is attached qvw? please attach it over here

senpradip007
Valued Contributor III

Re: Re: Getcurrentselection

PFA

ramasaisaksoft
Valued Contributor III

Re: Getcurrentselection

Good Work Thank u very much .Today i learn new Topic in QV

sunilkumarqv
Valued Contributor II

Re: Getcurrentselection

In case you not open file .follow

AS of Gysbert ,

Script

T1:

load * inline [

field1

a

b

c

];

T2:

load * inline [

field2

a

b

c

'a,b,c'

'a,b'

'b,c'

];

Then go to document properties  field event triggers on select- add action- select in field

Field as field2

Search string

=concat(field1,',')

vidyut
Contributor II

Re: Getcurrentselection

You could also use And mode of the ListBox in this case.

Community Browser