topic Re: Show/hide sheet for few users in QlikView

Show/hide sheet for few users

sridhar_sigired — Mon, 19 Sep 2016 10:10:29 GMT

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

Re: Show/hide sheet for few users

c_gilbert — Mon, 19 Sep 2016 10:17:36 GMT

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.

Re: Show/hide sheet for few users

Anonymous — Mon, 19 Sep 2016 10:22:41 GMT

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

Re: Show/hide sheet for few users

sridhar_sigired — Mon, 19 Sep 2016 10:27:57 GMT

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)

Re: Show/hide sheet for few users

MindaugasBacius — Mon, 19 Sep 2016 10:28:25 GMT

Try like this:

Re: Show/hide sheet for few users

adamdavi3s — Mon, 19 Sep 2016 10:29:24 GMT

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

Re: Show/hide sheet for few users

sridhar_sigired — Mon, 19 Sep 2016 10:51:36 GMT

Hi,

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

Re: Show/hide sheet for few users

sridhar_sigired — Mon, 19 Sep 2016 10:58:55 GMT

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?

Re: Show/hide sheet for few users

richard_chilvers — Mon, 19 Sep 2016 11:02:05 GMT

...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.

Re: Show/hide sheet for few users

adamdavi3s — Mon, 19 Sep 2016 11:03:08 GMT

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

Re: Show/hide sheet for few users

adamdavi3s — Mon, 19 Sep 2016 11:07:17 GMT

Use this formula on the sheets to account for NULLS

=if(len(only({<userid={$(=OSUser())}>}show1))<1,0,only({<userid={$(=OSUser())}>}show1))

As Richard has said, if it is only a few users then hard-coding them and using a match will be quickest, my solution will allow you to update easilly and also pull from a SQL table / spreadsheet if you wanted.

Its more complex but IMHO more future-proof

Re: Show/hide sheet for few users

sridhar_sigired — Mon, 19 Sep 2016 11:42:44 GMT

Yes, i have only 3 fixed users who need to see this sheets. I have tried the below formula for sheet condition.

The first user is mine, i can able to see the sheet even if i keep this or remove this. In the both cases, i can able to see sheet.

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

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

Re: Show/hide sheet for few users

adamdavi3s — Mon, 19 Sep 2016 11:47:31 GMT

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)