Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
saumyashah90
Specialist
Specialist

two columns and trigger

i have two columns

ColA and ColB

223          225

224          223

225          224

these have same values.

So o have made something like...when a person click on 223 in ColA, automatically 223 will get selected in ColB

using a variable.

and same if a person select on 224 on ColB  automatically 224 from colA gets selected.

now i want to deselect both if any one of it gets deselected

for example if i deselect 225 in ColB , selection should get removed from ColA also

Also i should be able to click on multiple fields together

21 Replies
sunny_talwar

I am not really sure how your data is structured. Would you be able to share a sample application?

avinashelite

Try like this :

you need to make use of Onselect and Onchange triggers on the two fields and based on the selection i.e 0 or more you need to set the corresponding conditional trigger

MayilVahanan

HI

May be try like attachment

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
saumyashah90
Specialist
Specialist
Author

Hi Sunny,

its simple.

Two columns not linked with each other.

But values inside are same.

Just need selection and deselection of both column values to get effected at the same time

saumyashah90
Specialist
Specialist
Author

Hi Mayil,

I appreciate your efforts,

but i cannot make any changes in script.Just think i dont have permissions.

I just need to work on UI

LOAD COLB Resident T1;

DROP Field COLB From T1;

This i know its correct but i cannot use.

I only have to work on front end

himanshi
Contributor III
Contributor III

hi,

can you explain how did you do that.

MayilVahanan

Hi

If you have only two fields, then try like attachment.

Document properties -> Tables -> Check the loosely coupled tables.

It breaks the link between the fields in that table. so u can achieve it..

But its strongly not recommended.

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
ahbzshk07
Contributor III
Contributor III

Hello Saumya!

I believe setting triggers itself will solve your issue. You wont have to do anything in script, unless those two fields have same values.

Just in addition to Mayil's solution, use this:

For COLA trigger: (onSelect) Select in field: COLB ; Search string ='('&GetFieldSelections(COLA,'|')&')'

For COLB trigger: (onSelect) Select in field: COLA ; Search string ='('&GetFieldSelections(COLB,'|')&')'

These changes will work for multiple selections as well...

Thanks & Regards,

Shabaz Shaikh

ahbzshk07
Contributor III
Contributor III

*unless those two fields have different values...

Sorry for my mistake...