topic Re: Sheet Trigger in QlikView

Sheet Trigger

polisetti — Mon, 20 Oct 2014 10:04:56 GMT

Hi QV,

I need to change the sheets depending on the Selection. Consider I have a Role selection. ,if I Click on Role A from the Role field, it should goes to Sheet 1, If I click on Role 2 it should redirect to sheet 2.Will it be possible by writing triggers at document level?

If yes please help me to achieve this thing done.

Thanks in Advance,

Regards,

Polisetti.

Re: Sheet Trigger

Peter_Cammaert — Mon, 20 Oct 2014 10:08:24 GMT

Yes, that's possible but you'll need a Field Trigger that fires when changes are made to the Role field.

Go to Settings->Document Properties->Triggers->Field Event Triggers, select your field and use OnSelect/OnChange to activate a specific sheet.

Re: Sheet Trigger

polisetti — Mon, 20 Oct 2014 10:19:30 GMT

Yeah, but we need to write a specific condition on specific Role. So how to do that ?

I have total 4 Roles, On Role A it should be sheet 1 & For other Roles it should be Sheet 2.

Regards,

Re: Sheet Trigger

Anonymous — Mon, 20 Oct 2014 10:29:23 GMT

Hi polisetti,

Create a variable vRole that takes value from 1 to 4 depending of Role selection, like:

=if(only(Role)='RoleA', 1, if(only(Role)='RoleB', 2, if(only(Role)='RoleC', 3, if(only(Role)='RoleD', 4,))))

and edit the condition to show/hide each sheet like:

=if($(vRole)=1, 1,0) in sheets you want to show for RoleA

=if($(vRole)=2, 1,0) in sheets you want to show for RoleB

and so for the others.

Marc.

Re: Sheet Trigger

Peter_Cammaert — Mon, 20 Oct 2014 10:34:57 GMT

Put something like:

=IF (Only(Role) = 'Role A', 'SH01',

IF (Only(Role) = 'Role B', 'SH02',

IF (Only(Role) = 'Role C', 'SH03', 'SH04')))

In the Sheet ID field of the Layout->Activate action. Note that you have to change the Sheet IDs to values that exist in your document and correspond to the correct target sheets.

Peter

Re: Sheet Trigger

Peter_Cammaert — Mon, 20 Oct 2014 10:36:09 GMT

Correction: the expression is simpler:

=IF(Only(Role) = 'Role A', 'SH01', 'SH02')

That's it.

Good luck,

Peter