Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Master III
Master III

Triggers Issue !!!! Challenge

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.

4 Replies
Highlighted
Partner
Partner

Re: Triggers Issue !!!! Challenge

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

It works now, see attached.

Highlighted
Not applicable

Re: Triggers Issue !!!! Challenge

Hi

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.

Highlighted
Master III
Master III

Re: Triggers Issue !!!! Challenge

Good !!

And thanks !

Highlighted
Partner
Partner

Re: Triggers Issue !!!! Challenge

Your welcome,

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