Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sheet selections based on user

Good Day,

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.

thank you

Kallie

3 Replies
Anonymous
Not applicable
Author

Hi,

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.

Not applicable
Author

Hi,

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.

Sheet 20

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

]

SP, SALMAN_CD

SP1, 01

SP2, 02

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.

Thank you

Kallie

Anonymous
Not applicable
Author

Hi Kallie,

I am not clear on your requirements.

Have few question-

  • How are you creating these groups?. What does Group1 consists of and Group2?
  • Is User1 and User2 related to the same group i.e. Group2? And what are these User1 and User2? (Stephen & Dirk in your table?)
  • How are these User1&2, Sp1&2 and Group1&2 related.

Few things I can suggest for sheet level access is to create a separate table under "Section Application" section (below Section Access table)

Section Access;

---

---

---

;

Section Application;

LOAD * INLINE [

USERID(or NTNAME), SHEET01,SHEET2

Stephen,1,0

Dirk,1,1

];

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.

Hope this helps.

Thanks and Regards,

Laxmi