topic Re: Sheet Trigger in QlikView

Sheet Trigger

phillipmacd — Mon, 13 Jul 2020 12:32:03 GMT

Hi All, hope someone could help me with my problem.

I have triggers setup "OnActivateSheet" where I select in field values depending on a user (OSUser()) to filter data for that user, then lock that field so that users can't see other user's data.

The problem I have is when it is a "manager" that is supposed to see all data, that user can see everything because that user is not in the list of the trigger, but the values in that field can't be selected to filter.

eg.

I add a trigger (OnActivateSheet) , Select in Field, add the field , in the search string I add an IF statement that does the selection ( IF(match(OSUser(UserName),'User1',User1,

IF(match(OSUser(UserName),'User2',User2)),

then I lock the field.

When User3 opens the sheet, all the data is available , but User3 can't select any values in the "UserName" field.

I tried adding the "unlock field" option with criteria (IF(match(OSUser(UserName),'User3',UserName) but no luck....

Any Ideas on where my issue might be.

Regards

Re: Sheet Trigger

Miguel_Angel_Baeyens — Tue, 14 Jul 2020 10:47:59 GMT

Why not trying with section access? https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Security.htm

When a user opens the app, depending on the access to you have established for each of them, they will only see the data associated with them as well as the sheets (if you want to) only relevant for such user.

Re: Sheet Trigger

MindaugasBacius — Tue, 14 Jul 2020 11:02:36 GMT

That's not the best approach as the more advanced user can simply unlock the fields and then navigate through other users' data.

Section access could be your answer.

Re: Sheet Trigger

phillipmacd — Tue, 14 Jul 2020 11:08:54 GMT

Hi Miguel , will definitely have a look, never work with section access before. the tricky part on my side is the Username for each user isn't a 100% match to their username in the data. So I hard code the matching user to the name in the data

eg. Username = JohnK , name in data = JOHN

Username = John.JamesL , name in data = JJ

and so on....

the data name is stored in a mapping table which gets updates by the users to link them to their clients.

but will see if I can use section access to solve my issue

thank you very much for the input