User specific selections - OnOpen Document Event Trigger

[#1]

Hi all.

I have many Qlikview users, each belongs to at least one team. A table containing users and the teams they belong to is included in the load script.

When a user opens a document I want the team selection to automatically reflect the team they belong to.

Is there an OnOpen Document Event Trigger I can use which applies a selection to the team field depending on which user opens the document?

Many thanks, Michael.

[erichshiino · Accepted solution]

Hi, Michael.

I implemented this using section access and the option of initial section based on section access.

In this example, when QlikView asks for UserID you can use A, B, C or MANAGER.

In the real App you can define the team based on the user login (with NTNAME on section access).

Please, check the script and Document Properties- > Opening

[disqr_rm]

Take a look at http://robwunderlich.com/downloads/

Rob has provided an excellent example of Initial Selections. While there, you can also see other very valuable creations of his.

Rakesh

[#4]

Thanks for your responses.

I found a solution whereby I renamed the team field in the section access file and applied this to an OnOpen Select in Field trigger for the actual team field. That way section access restrictions are not applied (because the field names for team do not match) but the team selection is applied. I hope that makes sense - although Erich's solution seems a little simpler!