topic Re: Triggers Issue !!!! Challenge in QlikView

Triggers Issue !!!! Challenge

sujeetsingh — Wed, 31 Jul 2013 07:01:06 GMT

Hello Experts,

I am struggling with an issue for last 4 days. I am posting the sample below.

Actually i am having two listboxes 'Tables' and 'Charts' .

Tables have field tables and Charts have field Chart . Both fields have trigger .

Open the qvw i have explained in it the issue.

Re: Triggers Issue !!!! Challenge

orital81 — Wed, 31 Jul 2013 07:26:46 GMT

I added the charts trigger to both table ans charts objects.

It works now, see attached.

Re: Triggers Issue !!!! Challenge

Wed, 31 Jul 2013 07:34:40 GMT

The problem here is that each trigger only looks at the value of the field you are dealing with, it doesn't take any action when that field is cleared, therefore, when a field is cleared it doesn't know which sheet to activate and therefore defaults to the sheet immediately prior to the active one.

Your Trigger on Tables should be:

=if(GetFieldSelections(Tables)='A','SH02',
   if(GetFieldSelections(Tables)='B','SH03',
    if(GetFieldSelections(Tables)='C','SH04',
     if(GetFieldSelections(Tables)='D','SH05',
      If(GetFieldSelections(Charts)='P','SH06',
           if(GetFieldSelections(Charts)='Q','SH07',
        if(GetFieldSelections(Charts)='R','SH08')))))))

Your trigger on Charts should be

=If(GetFieldSelections(Charts)='P','SH06',
    if(GetFieldSelections(Charts)='Q','SH07',
     if(GetFieldSelections(Charts)='R','SH08',
      if(GetFieldSelections(Tables)='A','SH02',
       if(GetFieldSelections(Tables)='B','SH03',
        if(GetFieldSelections(Tables)='C','SH04',
         if(GetFieldSelections(Tables)='D','SH05')))))))

And finally, you only have triggers placed On Select, and a clear function is not a select, so you also need to add the exact same trigger to the on Change button.

Re: Triggers Issue !!!! Challenge

sujeetsingh — Wed, 31 Jul 2013 07:37:59 GMT

Good !!

And thanks !

Re: Triggers Issue !!!! Challenge

orital81 — Wed, 31 Jul 2013 07:41:44 GMT

Your welcome,

Just note that you should do the same for table list box