topic Re: Section Access problem Sheet Level in QlikView

Section Access problem Sheet Level

stonecold111 — Wed, 25 Nov 2020 16:16:04 GMT

hi qlikksss

SECTION Access;

LOAD

ACCESS,

NTNAME

FROM

(ooxml, embedded labels, table is Sheet1);

SECTION Application;

SHEET_LEVEL:

LOAD

NTNAME,

SHEET1

FROM

(ooxml, embedded labels, table is Sheet2);

And i used condtional show for sheet1 as =ONLY(SHEET1)=1

in my excel file in Sheet1

ADMIN,GOOGLE\SURESH

ADMIN,GOOGLE|SATHISH

USER,GOOGLE\MARTIN

in Sheet2

NTNAME,SHEET1

GOOGLE\SURESH,1

GOOGLE\SATHISH,1

GOOGLE\MARTIN,0

when i relaod through server even for GOOGLE\MARTIN Sheet1 is visible. Imagine my server is running on GOOGLE\SURESH

account. Even when i logged in as GOOGLE\MARTIN Sheet1 is visible. Any suggestionsss

Re: Section Access problem Sheet Level

trdandamudi — Tue, 18 Jul 2017 11:34:06 GMT

Did you checked the below two options as circled below ? Hope this helps...

Re: Section Access problem Sheet Level

antoniotiman — Tue, 18 Jul 2017 12:06:15 GMT

Hi,

try this

=Only({<NTNAME={'$(=Upper(OSUser()))'}>} SHEET)

Regards,

Antonio

Re: Section Access problem Sheet Level

Anonymous — Tue, 18 Jul 2017 12:06:47 GMT

Also, Check in Doc properties -> Security -> show all sheets and objects is unchecked

Re: Section Access problem Sheet Level

stonecold111 — Tue, 18 Jul 2017 12:37:09 GMT

Yes I did

Re: Section Access problem Sheet Level

stonecold111 — Tue, 18 Jul 2017 12:37:31 GMT

Will try n come back

Re: Section Access problem Sheet Level

stonecold111 — Wed, 19 Jul 2017 07:33:25 GMT

if i use strict exclusion as well with intial data reduction

Failed to open document. you don't have access to this document

Re: Section Access problem Sheet Level

stonecold111 — Wed, 19 Jul 2017 07:35:31 GMT

yes it's unchecked

Re: Section Access problem Sheet Level

stonecold111 — Wed, 19 Jul 2017 08:24:06 GMT

No it's not working

Re: Section Access problem Sheet Level

stonecold111 — Wed, 19 Jul 2017 08:24:24 GMT

still sheet is visible

Re: Section Access problem Sheet Level

jmvilaplanap — Wed, 19 Jul 2017 08:29:31 GMT

Why you don't use the Show Sheet option? Is in Sheet Properties

Re: Section Access problem Sheet Level

stonecold111 — Wed, 19 Jul 2017 08:32:29 GMT

if i remove GOOGLE\SURESH,1 in excel( GOOGLE\SURESH is server domain )

then it is working fine for GOOGLE\MARTIN in access point

If i keep my server domain it is by default taking

GOOGLE\SURESH = 1

for all users and showing sheet to everyone

Any suggestions

Re: Section Access problem Sheet Level

stonecold111 — Wed, 19 Jul 2017 08:33:15 GMT

i want to hide that sheet for some users and show for some users in access point

Re: Section Access problem Sheet Level

stonecold111 — Wed, 19 Jul 2017 08:35:24 GMT

i want to hide sheet for GOOGLE\MARTIN in access point

i think u got my point

Re: Section Access problem Sheet Level

jmvilaplanap — Wed, 19 Jul 2017 08:35:31 GMT

Then is possible to use this option

Only use a formula in the conditional field. (SHEET1 = 1)

Re: Section Access problem Sheet Level

jmvilaplanap — Wed, 19 Jul 2017 08:36:25 GMT

In the conditional field write:

= if(OsUser() = 'GOOGLE\MARTIN', 1, 0)

Re: Section Access problem Sheet Level

antoniotiman — Wed, 19 Jul 2017 08:37:42 GMT

Have You changed from SHEET to SHEET1 in my expression ?

Re: Section Access problem Sheet Level

stonecold111 — Wed, 19 Jul 2017 08:43:23 GMT

this is same as =ONLY(SHEET1)=1

still i tried this

But i add my server domain

GOOGLE\SURESH,1

Sheet is visible for everyone. By default it only taking GOOGLE\SURESH=1

and showing for everyone

if i remove my server domain it's working properly

Re: Section Access problem Sheet Level

Siva_Sankar — Wed, 19 Jul 2017 08:44:53 GMT

Hi Suresh,

Follow the steps mentioned in this document.Sheet level access

It is more simpler than what you have. Make sure you need to use UPPER() function for NTNAME and other fields.

If it didnt help, upload a example or sample file with the same script of what you have.

-Siva

Re: Section Access problem Sheet Level

stonecold111 — Wed, 19 Jul 2017 08:46:32 GMT

yes already we are using this only

= mixmatch(OsUser() = 'GOOGLE\MARTIN', 'GOOGLE|SATHISH' ....... so on)

But i want this access in Excel