topic Re: Hidden Sheet in QlikView

Hidden Sheet

Wed, 06 Aug 2014 05:34:17 GMT

Hi All

I am tasked to build a functionality that will only be used by the ADMIN Users. This functionality must be placed in a hidden sheet which I should only make available to ADMIN Users.

How do I make a sheet available to only specific Users?

Re: Hidden Sheet

ashfaq_haseeb — Wed, 06 Aug 2014 05:36:03 GMT

Hi,

You can

Have a look at osuser() function.

Regards

ASHFAQ

Re: Hidden Sheet

avinashelite — Wed, 06 Aug 2014 05:37:29 GMT

Hi Tumelo,

Go to sheet properties and use conditional show.

use condition like if(role='Admin',1,0)

Re: Hidden Sheet

amit_saini — Wed, 06 Aug 2014 05:39:59 GMT

Tumelo,

Please see the attachment.

Use Username : admin

Password: admin

Also please see the link below:

Re: OSUser(): Visible data restricted through user

Thanks,

Re: Hidden Sheet

tresB — Wed, 06 Aug 2014 05:43:15 GMT

Right click on the sheet-> General tab->Show Sheet (Conditional)

Expression like: Osuser()='Peter' // this will make the sheet available only to Peter

Re: Hidden Sheet

Wed, 06 Aug 2014 06:16:04 GMT

Thanks a lot for the prompt response guys, you were all helpful.

This community is awesome!