topic Re: corresponding listbox values come with selection automatically and viceversa in QlikView

corresponding listbox values come with selection automatically and viceversa

Wed, 12 Dec 2012 05:28:41 GMT

Hi all,

I have 2 fields say F1 and F2

assume this is the data

F1,F2

A,1

B,2

C,3

D,4

I have taken these 2 fields in seperate listboxes.

Now if i select F1 listbox data,the corresponding data in F2 listbox needs to select automatically and viceversa.

I am doing this process but not achieve the exact result.

Field even trigger->Onselect for F1

Action1->Clearfield->F2

Action2->SelectPossible->F2

Action3->ClearField->If(GetSelectedCount(F1)>0,'F2')

It is not exactly working at the time of deselecting F1.

I need your ideas on this one.

Thanks in advance.

Regards

Kumar

Re: corresponding listbox values come with selection automatically and viceversa

Wed, 12 Dec 2012 05:43:02 GMT

Hi,

By default list boxes has the functionality that are asking.

and why are you using triggers??

If you need only value to select at a time, use the option: general->always one selected value option

regards,

Niranjan M

Re: corresponding listbox values come with selection automatically and viceversa

Wed, 12 Dec 2012 05:46:31 GMT

Hi,

Just go to document property -> select triggers tab.

There you can see the field event triggers. Select F1 field and click the button OnSelect and add the action as select possible. This will ask you the field name, there you give the field name as just F2. This will work.

Thanks,

Srini.

Re: corresponding listbox values come with selection automatically and viceversa

sujeetsingh — Wed, 12 Dec 2012 05:49:57 GMT

Paste a sample..

Dear listboxes have the linking..by default

Re: corresponding listbox values come with selection automatically and viceversa

Wed, 12 Dec 2012 05:54:09 GMT

Niranjan,

I think u didn't get my point

I don't want to select the F2 directly.

But i need to catch those values in a variable.

The only option for me is i can select F1.

So when i select F1,the corresponding F2 values come with selections(Green color).

At this time i can write the expression for catching the values of F2 in a variable.

Hope now you understand.

Regards

Kumar

Re: corresponding listbox values come with selection automatically and viceversa

Wed, 12 Dec 2012 06:52:46 GMT

Hi,

I placed a sample application with requirement, hope it will help You.

Niranjan M.

Re: corresponding listbox values come with selection automatically and viceversa

Mon, 17 Dec 2012 10:25:49 GMT

Hi guys,

Sorry for the late reply.I don't have the software even personel edition.

Now i am having that one.

here i am attaching one sample app with my requirements inside of the app.

Plz check and give your quick responses.

Regards

Kumar

Re: corresponding listbox values come with selection automatically and viceversa

Mon, 17 Dec 2012 10:33:52 GMT

Niranjan,

Sorry for late reply.

Your solution was helpul to me.

Can you please check my attached sample file and send me your response for the Note:3 in the attached app.

regards

kumar

Re: corresponding listbox values come with selection automatically and viceversa

Mon, 17 Dec 2012 10:42:58 GMT

Just this expression will provide you the note 3.

=Concat(F1ID&'.'&F2ID,',')

Thanks,

Srini

Re: corresponding listbox values come with selection automatically and viceversa

beeaj2011 — Tue, 29 Jan 2013 20:59:13 GMT

Great stuff Niranjan

it is very useful for me for a country / currency selection !!

Took me a few moments to find the trigger(s) behind the fields on document settings , perhaps `I didn't read the whole blog on this

thnx

Ton Kattevilder

Re: corresponding listbox values come with selection automatically and viceversa

Thu, 31 Jan 2013 11:40:32 GMT

Hi Ravi,

As per my understanding i had done in attached qvw file.

If i was wrong let me know.

Best of luck

Re: corresponding listbox values come with selection automatically and viceversa

beeaj2011 — Thu, 31 Jan 2013 11:51:15 GMT

Yes that is true but I dod have to do some searching to find that

Kind Regards

Ton Kattevilder

06 48752578

tkattevilder@beeajconsult.nl

Van: Satish venkat <qcwebmaster@qlik.com<mailto:qcwebmaster@qlik.com>>

Beantwoorden - Aan: "jive-2075937090-12zi-2-6k7u@community.qlik.com<mailto:jive-2075937090-12zi-2-6k7u@community.qlik.com>" <jive-2075937090-12zi-2-6k7u@community.qlik.com<mailto:jive-2075937090-12zi-2-6k7u@community.qlik.com>>

Datum: donderdag 31 januari 2013 12:40

Aan: Ton Kattevilder <tkattevilder@beeajconsult.nl<mailto:tkattevilder@beeajconsult.nl>>

Onderwerp: - Re: corresponding listbox values come with selection automatically and viceversa

QlikCommunity<http://community.qlik.com/index.jspa>

Re: corresponding listbox values come with selection automatically and viceversa

created by Satish venkat<http://community.qlik.com/people/venkatveer> in Development (QlikView Desktop) - View the full discussion<http://community.qlik.com/message/306138#306138>