topic Re: osuser() to hide sheet not working in QlikView

osuser() to hide sheet not working

sifatnabil — Fri, 05 Feb 2016 10:12:38 GMT

Hi all,

I have a sheet that I want to hide to specific users bases on OSuser().

I used this in the conditional show:

=if(match(osuser(),

'GLOBAL\A',

'GLOBAL\B',

'GLOBAL\C',

'GLOBAL\D',

'GLOBAL\E')=0,0)

Meaning that if the user doesn't match A, B, C, D, or E, the sheet will be hidden. However, user C cannot see the sheet, whereas user D can. Why would this happen? Thanks.

Re: osuser() to hide sheet not working

Anonymous — Fri, 05 Feb 2016 10:25:28 GMT

I presume you have given sample users above.

For your real if() with the real users I would double check for any typo's.

Re: osuser() to hide sheet not working

sifatnabil — Fri, 05 Feb 2016 10:28:04 GMT

I've checked for typos - the expression works locally between my server account and normal account. e.g. if I my server account is D, and I open the doc on my server account, I can view the sheet. The same if opened on my normal account, hides the sheet. So I'm expecting it to work on the server but it's not.

Re: osuser() to hide sheet not working

Peter_Cammaert — Fri, 05 Feb 2016 10:30:38 GMT

Check the ID that is displayed in the AccessPoint page (top right corner) for user D. Does it match GLOBAL\D?

Also two suggestions:

Security-wise it's always better to expressly permit someone to see the sheet instead of revoking rights from listed users. The default security should be "DENY".
Always add an "otherwise" value to your condition, as the default NULL value may prove very unreliable. Your conditional show then becomes:

=if(match(osuser(),

'GLOBAL\A',

'GLOBAL\B',

'GLOBAL\C',

'GLOBAL\D',

'GLOBAL\E')=0, 0, 1)

Re: osuser() to hide sheet not working

sifatnabil — Fri, 05 Feb 2016 10:43:53 GMT

Checked the right corner, it seems capitalization matters. I was doing GLOBAL\user_a when the user was appearing as GLOBAL\User_A