topic Re: Getcurrentselection in QlikView

Getcurrentselection

Wed, 12 Mar 2014 14:01:12 GMT

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

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

Re: Getcurrentselection

alexandros17 — Wed, 12 Mar 2014 14:10:53 GMT

Which objects are involved?

Chart? Multibox?

Let me know

Re: Getcurrentselection

Gysbert_Wassenaar — Wed, 12 Mar 2014 14:53:53 GMT

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.

Re: Getcurrentselection

Thu, 13 Mar 2014 05:51:47 GMT

where is attached qvw? please attach it over here

Re: Re: Getcurrentselection

senpradip007 — Thu, 13 Mar 2014 05:58:46 GMT

PFA

Re: Getcurrentselection

ramasaisaksoft — Thu, 13 Mar 2014 06:06:13 GMT

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

Re: Getcurrentselection

sunilkumarqv — Thu, 13 Mar 2014 06:35:42 GMT

In case you not open file .follow

AS of Gysbert ,

Script

T1:

load * inline [

field1

];

T2:

load * inline [

field2

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

Re: Getcurrentselection

vidyut — Thu, 13 Mar 2014 21:13:22 GMT

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