Section Access problem Sheet Level

[stonecold111]

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

[jmvilaplanap]

Hi

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

[stonecold111]

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

[stonecold111]

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

[stonecold111]

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

i think u got my point

[jmvilaplanap]

Then is possible to use this option

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

[jmvilaplanap]

In the conditional field write:

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

[antoniotiman]

Have You changed from SHEET to SHEET1 in my expression ?

[stonecold111]

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

[Siva_Sankar]

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

[stonecold111]

yes already we are using this only

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

But i want this access in Excel