topic Re: two columns and trigger in QlikView

two columns and trigger

saumyashah90 — Tue, 15 Dec 2015 12:23:22 GMT

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

Re: two columns and trigger

sunny_talwar — Tue, 15 Dec 2015 12:27:15 GMT

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

Re: two columns and trigger

avinashelite — Tue, 15 Dec 2015 12:27:29 GMT

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

Re: two columns and trigger

MayilVahanan — Tue, 15 Dec 2015 12:38:00 GMT

May be try like attachment

Re: two columns and trigger

saumyashah90 — Tue, 15 Dec 2015 15:37:26 GMT

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

Re: two columns and trigger

saumyashah90 — Wed, 16 Dec 2015 02:13:33 GMT

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

Re: two columns and trigger

himanshi — Wed, 16 Dec 2015 06:52:20 GMT

hi,

can you explain how did you do that.

Re: two columns and trigger

MayilVahanan — Wed, 16 Dec 2015 07:08:02 GMT

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.

Re: two columns and trigger

ahbzshk07 — Wed, 16 Dec 2015 07:08:06 GMT

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

Re: two columns and trigger

ahbzshk07 — Wed, 16 Dec 2015 07:10:14 GMT

*unless those two fields have different values...

Sorry for my mistake...

Re: two columns and trigger

ahmar811 — Wed, 16 Dec 2015 07:23:35 GMT

Hi Saumya

PFA

hope this help you

Regards

Ahmar

Re: two columns and trigger

tresB — Wed, 16 Dec 2015 07:30:34 GMT

Like this?

Re: two columns and trigger

settu_periasamy — Wed, 16 Dec 2015 07:43:38 GMT

Hi,

Check the attachment. Trigger with Multiple Selection..

Re: two columns and trigger

saumyashah90 — Wed, 16 Dec 2015 08:45:37 GMT

Hi its working good for one selection.

What can be done for multiple selection

Re: two columns and trigger

tresB — Wed, 16 Dec 2015 08:51:18 GMT

For multi-selection. PFA

Re: two columns and trigger

saumyashah90 — Wed, 16 Dec 2015 09:00:32 GMT

Hi Tres,

this looks good for single select but can we do it for multiple selection

Re: two columns and trigger

tresB — Wed, 16 Dec 2015 09:01:47 GMT

Check my other attachment above.

Re: two columns and trigger

saumyashah90 — Wed, 16 Dec 2015 09:45:48 GMT

Hi tres,

This looks good.

But now i have twist in this.

In colB i have -> 1234_223

2312_224,

3423_225

i need to select this column, can we do it?

Re: two columns and trigger

saumyashah90 — Wed, 16 Dec 2015 09:50:23 GMT

This looks good.

But now i have twist in this.

In colB i have -> 1234_223

2312_224,

3423_225

i need to select this column, can we do it?

Re: two columns and trigger

settu_periasamy — Wed, 16 Dec 2015 09:53:06 GMT

Hi,

Check this..