Hide a sheet for a specific user

[hafaneh]

I have a sheet with some charts that I want to share with a specific user, and I want to ensure that no other users can access this sheet

im using qlik cloud and i already have Section Access for the app for users to see  a specific store . 

anyhelp on how to do it? 

[MatheusC]

Hi, @hafaneh  in the display condition use the function

SubField(OSUser())

example:

='$(=SubField(OSUser(),'=',-1))'<>'user'

hiding to this specific user

[HAmzehAF]

hello @MatheusC 
im tryung to do it but it still showing for everyone im using an email not user 

[Vegar · Accepted solution]

You won't have access to users email in Qlik Sense apps, if you need that then you need to add that as an data set and associate it to a field containing the osuser() value. With that datamodel you could create a show condition statement comparing email adress with email adress associated with the osuser()

[HAmzehAF]

even in the qlik cloud that uses an emails to login ? 

[Vegar]

Try creating an object where you use osuser() to see what you get as output
when you access it. That will help you understand what kind of ID the
function returns.
- Vegar

[HAmzehAF]

hello,
when i use the osuser() i only get the professional user that the sys have and its me i dont see the people im using in the section accecs( that im using eamil,store code) i used a table one collme is onuser and the other is the store code 

any ideas? 
@Vegar 

[MatheusC]

Hi, @HAmzehAF 

I also use qlik cloud, there is no need for an email to block it, just the user already works.

I believe the confusion may be that when using this function, it will return the access user at that time, which in this case is yours, but if you use the block of the respective user you want to block, it will work in the same way.

as sujeri ='$(=SubField(OSUser(),'=',-1))'<>'lock user'

If you can access the user you want to block, test it

You may also want to do the opposite, instead of blocking a user, release it to 2 or 3 specific users if you need to change the sign to '=', for example:

='
$(=SubField(OSUser(),'=',-1))'='user1'
or
'$(=SubField(OSUser(),'=',-1))'='user2'

[HAmzehAF]

sorry for asking so many stuff , 

i want to know which 'user' u mean i have userid, email and IdP subject,

now when i use this on a table to check if the onuser change it does like u said and i get it like for the user im using, 

but i wanna know 
'$(=SubField(OSUser(),'=',-1))'<>'lock user'
for this when i use like the name of the user i still can see the page im not getting it like this 

@MatheusC 

[MatheusC]

@HAmzehAF 
The UserId, which will be used for blocking

You can notice that there is a hidden symbol next to the name of the sheet, that is, the block for this print user was made.

However, it still appears because you are a professional user and must not have applied the change yet.

print do userID