OnActivate Trigger selection prevents access to sheet

michael_anthony — Thu, 01 Dec 2011 02:42:47 GMT

Hi,

In my qvw on certain sheets have an OnActivate trigger which Select In Field. Field is ROLE and Search String is (KAM|AM). Works fine for me and users who have access to data for both 'KAM' and 'AM' ROLE's. But a user who only has 'KAM' ROLE (using data reduction) cannot enter the sheet, presumably because the selection fails or runs into security issue.

If the Search String is (KAM|abc) where abc isn't a valid entry for ROLE, the user can enter the sheet and it selects KAM.

Is this a bug. I'd like the security to prevent the user seeing the 'AM' data, but not being locked out of the sheet entirely as they can see 'KAM' data. I can revert to using macro's or other workaround, but like to know if there is a better solution.

Using v10 SR3 with IE plug in (same version).

Thanks,

Michael

topic OnActivate Trigger selection prevents access to sheet in QlikView

OnActivate Trigger selection prevents access to sheet