Solved: Show/hide sheet for few users - Qlik Community

sridhar_sigired · ‎2016-09-19

Hi,

I have one sheet where i need to show only few users. Can we do this without using section access? If yes, how we can achieve this?

If No, can have process how can we do this? Please help me. Thanks.

Regards,

Sridhar

adamdavi3s · ‎2016-09-19

Try adding the negative result to the IF as well

=if(match(Upper(OSUser()),'CTC\SRIDHAR_S', 'CTC\RAJESH_Y', 'CTC\BHOPESH_Y')>0,1,0)

=if(match(Upper(OSUser()), 'CTC\RAJESH_Y', 'CTC\BHOPESH_Y')>0,1,0)

View solution in original post

c_gilbert · ‎2016-09-19

You could use a button which controls a variable (and have it say something like "Show X sheet"), then you could change the show condition of that sheet to correspond with the variable.

Anonymous · ‎2016-09-19

you can use osuser() to get the Name of user

then pass to a variable like

vSheetAllowed= (if (osuser()<>'NAME1' and osuser() <> 'NAME2',1,0)

look for exact Format of osuser()

then you may define in sheet properties, Show conditional

vSheetAllowed=1

sridhar_sigired · ‎2016-09-19

Hi,

Can we create variable like below? I have to give access of sheet to 3 users.

vSheetAllowed= (if (osuser()='NAME1' or osuser() = 'NAME2' or osuser() = 'NAME3',1,0)

MindaugasBacius · ‎2016-09-19

Try like this:

adamdavi3s · ‎2016-09-19

Hi,

You can use OSUSER() OR QVUSER() Function and then match this to a table which control access.

Please see the attached example app, just change your username in the load script.

There are two additional tabs which will show / hide depending on the setting you make

sridhar_sigired · ‎2016-09-19

Hi,

If we implement this, Jonny and Joe are going to see sheet? or... I have tried this, but could not able to get...

sridhar_sigired · ‎2016-09-19

In this case, do we need to add all user information to whom we are giving file access?

Or only those users are enough to whom we need to show this sheet?

richard_chilvers · ‎2016-09-19

...that's up to you depending on how your write your conditional statement. If only a couple of people need to see the sheet, its quicker and easier to just include their user IDs in the statement, as mindaugasbacius has shown above.

adamdavi3s · ‎2016-09-19

In my example, only those who need to see the sheet as if the user doesn't exist it shouldn't be true and so the sheets won't show at all.

*edit* sorry no that isn't true which is interesting. Let me amend the formula slightly