Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
rarora12
Contributor

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
Highlighted
vinieme12
Esteemed Contributor II

Re: Cannot get Sheet security to work with NTName

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

View solution in original post

11 Replies
Highlighted
vinieme12
Esteemed Contributor II

Re: Cannot get Sheet security to work with NTName

Read this post

Sheet Level Security

Highlighted
rarora12
Contributor

Re: Cannot get Sheet security to work with NTName

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

Highlighted
vinieme12
Esteemed Contributor II

Re: Cannot get Sheet security to work with NTName

it works if you do it correctly!

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

Highlighted
vinieme12
Esteemed Contributor II

Re: Cannot get Sheet security to work with NTName

also have you checked this box ?

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

Highlighted
Partner
Partner

Re: Cannot get Sheet security to work with NTName

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.

Highlighted
rarora12
Contributor

Re: Cannot get Sheet security to work with NTName

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

Highlighted
Partner
Partner

Re: Cannot get Sheet security to work with NTName

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.

Highlighted
vinieme12
Esteemed Contributor II

Re: Cannot get Sheet security to work with NTName

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

View solution in original post

Highlighted
vinieme12
Esteemed Contributor II

Re: Cannot get Sheet security to work with NTName

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

Section Access