Discussion board where members can get started with QlikView.
i wonder if anyone can assist me, i am trying to create a sheet were depending on user the current selections is locked.
ie user 1 = group 1
user2 = group 2
i am currently doing it with trigger but need to add more users to specific sheet with different selections as currently only one user has access.
If I am not wrong you are trying to hide/show the sheets based on the user logged in.
In that case I would suggest you to use section access at sheet level.
Section Access - Hide Sheet Level
Sheets Security with Section Access File
Sheet level access
Hope this helps.
It is yes and no.
I have designed the section access depending on user. But no the need has arisen that on this particular sheet I need to restrict them even more.
user1 sees group 2
user2 sees group 2
we have section access setup for the users. Ie
ACCESS, NTNAME , SP ,
USER, JOHNNY ,"*"
USER, STEFAN ,SP1
USER, DIRK ,SP2
But now the need has arisen to on certain sheets give them only SP Access according to SECTION ACCESS. But now I need to add group in their
Ie Johhny can see everything
but Stefan must be able to see group 1 and SP1
Dirk must only be able to see GROUP 2 and SP2
Which in essence will be clashing because group 2 can have a SP1 or a SP2 or how would I do that.
I thought of user based automatic selections
Ie Stefan opens sheet group1 is automatically selected on sheet and locked.
Dirk opens sheet and group2 is automatically selected on sheet and locked etc.
But not sure in which direction to go
Not sure if you are able to assist in this regard.
I am not clear on your requirements.
Have few question-
Few things I can suggest for sheet level access is to create a separate table under "Section Application" section (below Section Access table)
LOAD * INLINE [
USERID(or NTNAME), SHEET01,SHEET2
Here Stephen will only have access to SHEET01 and Dirk can access SHEET01 and SHEET2.
You can create your own table based on your requirements.
Thanks and Regards,