topic Re: Cannot get Sheet security to work with NTName in QlikView

Cannot get Sheet security to work with NTName

rarora12 — Tue, 08 Aug 2017 17:05:32 GMT

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];

Re: Cannot get Sheet security to work with NTName

vinieme12 — Tue, 08 Aug 2017 18:41:09 GMT

Read this post

Sheet Level Security

Re: Cannot get Sheet security to work with NTName

rarora12 — Tue, 08 Aug 2017 18:46:36 GMT

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

Re: Cannot get Sheet security to work with NTName

vinieme12 — Tue, 08 Aug 2017 18:50:23 GMT

it works if you do it correctly!

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

Re: Cannot get Sheet security to work with NTName

vinieme12 — Tue, 08 Aug 2017 18:56:30 GMT

also have you checked this box ?

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

Re: Cannot get Sheet security to work with NTName

krishnacbe — Tue, 08 Aug 2017 19:00:00 GMT

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.

Re: Cannot get Sheet security to work with NTName

rarora12 — Tue, 08 Aug 2017 19:17:22 GMT

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

Re: Cannot get Sheet security to work with NTName

krishnacbe — Tue, 08 Aug 2017 19:22:22 GMT

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.

Re: Cannot get Sheet security to work with NTName

vinieme12 — Tue, 08 Aug 2017 19:25:00 GMT

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

Re: Cannot get Sheet security to work with NTName

vinieme12 — Tue, 08 Aug 2017 19:34:16 GMT

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

Section Access

Re: Cannot get Sheet security to work with NTName

rarora12 — Tue, 08 Aug 2017 19:44:57 GMT

Thanks that worked!!

Re: Cannot get Sheet security to work with NTName

rarora12 — Tue, 08 Aug 2017 19:45:15 GMT

Thanks for your help also!!