Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rarora12
Creator
Creator

Cannot get Sheet security to work with NTName

I want certain users to access certain sheets based on their login NTNAME

I have tried adding the name of the sheets but the security does not work, what am I missing?

Thanks for your help in advance

Rick

Section Access;

security:

LOAD * INLINE [

    ACCESS, NTNAME

    user,B12A\ARORAR

];

Section Application; 

SheetAccess: 

LOAD * Inline [

NTNAME, Main,SH02

B12NA\ARORAR ,1,0];

1 Solution

Accepted Solutions
vinieme12
Champion III
Champion III

you are basically toggling sheet visibility using conditional show and the value you specify for that sheet

The 1's means true and 0's mean false

so for example your sheet name is say "SHEET1"

and in section access you've specified access for user ABC to sheet "sh1" = 1  ;

NTNAME,sh1

ABC,1

set conditional for SHEET1 =  sh1

now sh1 value for ABC = 1 which means show the Sheet1 for ABC

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

11 Replies
vinieme12
Champion III
Champion III

Read this post

Sheet Level Security

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
rarora12
Creator
Creator
Author

I have tried this as you will see in the code in my post, it simply does not work.

vinieme12
Champion III
Champion III

it works if you do it correctly!

have you set the variable in Sheet Properties >> Show Sheet >> Conditional = SH02 ?

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
vinieme12
Champion III
Champion III

also have you checked this box ?

Settings > Document Settings >> Opening >> Initial data reductions & Strict exclusion

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
krishnacbe
Partner - Specialist III
Partner - Specialist III

Hope you have enabled Strict Exclusion option under

Settings > Document Settings >> Opening >> Initial data reductions.

Please uncheck the option and check. as we are not reducing any data, just hiding the sheet, we don't need to check the Strict Exclusion.

rarora12
Creator
Creator
Author

Thanks for the setting check - yes i did that

why would i want to do the following? Sheet Properties >> Show Sheet >> Conditional = SH02

The sheets name is SHO2 why do I need to show conditional with =SH02 ??

Rick

krishnacbe
Partner - Specialist III
Partner - Specialist III

In your example you have 2 sheets I hope. you need to enable conditional show for two sheets.

In Main Sheet you need add Main and in SH02 you need to add SH02, so that the user B12NA\ARORAR can see Main Sheet and not SH02.

vinieme12
Champion III
Champion III

you are basically toggling sheet visibility using conditional show and the value you specify for that sheet

The 1's means true and 0's mean false

so for example your sheet name is say "SHEET1"

and in section access you've specified access for user ABC to sheet "sh1" = 1  ;

NTNAME,sh1

ABC,1

set conditional for SHEET1 =  sh1

now sh1 value for ABC = 1 which means show the Sheet1 for ABC

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
vinieme12
Champion III
Champion III

this post has link to most of the Section Access thread that you may find useful

Section Access

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.