topic Re: Restrict access to one sheet in QlikView

Restrict access to one sheet

Thu, 13 Mar 2014 11:32:51 GMT

I have seven sheets in my doc and I want sheet 7 only to be password protected when it is opened. The password would be a single password.

Thanks

Re: Restrict access to one sheet

Thu, 13 Mar 2014 14:01:21 GMT

You could create a variable for the password. Put an Input Box on the starting sheet that shows the password variable. The user inputs the password to the variable and your Layout conditions for other sheets check the Password value.

Re: Restrict access to one sheet

Thu, 13 Mar 2014 14:03:56 GMT

do you have an example of this i could follow pls

Re: Restrict access to one sheet

Colin-Albert — Thu, 13 Mar 2014 14:04:51 GMT

Have you considered using Section Access

http://community.qlik.com/docs/DOC-1853

Re: Re: Restrict access to one sheet

Thu, 13 Mar 2014 14:12:28 GMT

Screen will open with just input for Password.

If you enter the value "Password" as the password another sheet will become visible.

Re: Restrict access to one sheet

Thu, 13 Mar 2014 14:31:05 GMT

Hi no i havent come across this. Would this allow me to restrict just the one sheet

Re: Re: Restrict access to one sheet

Thu, 13 Mar 2014 14:32:14 GMT

Hi sorry Im not sure I follow this example.

Do you have a step example

Re: Restrict access to one sheet

Thu, 13 Mar 2014 14:39:49 GMT

When you open the application you will only see the main sheet. The main sheet has an input box for a variable which allows you to input a Password.

If you input the word "Password" for the password then another screen will become visible.

But if you input the word "QlikView" for the password then nothing will happen.

Re: Restrict access to one sheet

Thu, 13 Mar 2014 14:55:57 GMT

Colin

Can this be used to restrict a single sheet as it is not clear if thats possible in the doc.

Re: Restrict access to one sheet

Colin-Albert — Thu, 13 Mar 2014 15:49:40 GMT

With Section Access you can set a different password for different users and then restrict each user to view a specific sheet based on the user name, or data by using data reduction.

Re: Restrict access to one sheet

Colin-Albert — Thu, 13 Mar 2014 15:52:18 GMT

The section access password is either entered on opening the document, or can be linked to Active Directory login so the restrictions are applied automatically without the need for the user to be prompted for a login.

Re: Restrict access to one sheet

Carlos_Reyes — Thu, 13 Mar 2014 16:03:53 GMT

Following Colin's advice, perhaps this example may be useful.

Sheets Security with Section Access

Re: Restrict access to one sheet

Thu, 13 Mar 2014 16:50:19 GMT

Carlos thanks for this.

So what I want to be able to do is just have a single password on one sheet which only certain users will have access to. So is section access this method?

Sorry to be a pain but this bit is new me.

Re: Restrict access to one sheet

Carlos_Reyes — Thu, 13 Mar 2014 16:58:50 GMT

Hi,

Instead of adding a password for a sheet, you may enable or disable (hide or show) a sheet based on the User that is using the app. With Section Access you can use the NTNAME or Windows UserID to restrict the information that a user is allowed to see, but you can also use Section Access to enable or disable which sheets a user can see in the app.

The previous example (Sheets Security with Section Access) shows how to use Section Access to retrieve Active Directory's login information so that users don't need to log in or type a password to enter the app, and based on which user logs in, the app will show the correct information and enable the proper sheets so that each user only gets the information that's supposed to see.

Regards!

Re: Restrict access to one sheet

Thu, 13 Mar 2014 17:02:29 GMT

thanks for this.

So i would still need to set up the Section Access regardless in the method described.

Re: Restrict access to one sheet

Carlos_Reyes — Thu, 13 Mar 2014 17:23:27 GMT

Section Access would be the best option since it'll be the safest method. Dalton Ruer's option is easier to implement and to break since it depends on a password that user's may share with others.

I recommend you try to use Section Access.

Re: Restrict access to one sheet

Thu, 13 Mar 2014 17:26:54 GMT

okay thanks.

I wasnt clear how Dalton's option would work. Would you be able to provide me with info on that option so at least then i can make the choice.

Re: Re: Restrict access to one sheet

Carlos_Reyes — Thu, 13 Mar 2014 17:36:41 GMT

It's quite easy. Open the attached and type "password" (lower case) in the Enable Hidden Sheet box.

If you type any other value, the Hidden Sheet won't show. Once you enable the Hidden Sheet go to that Sheet properties and review the Show Sheet Conditional calculation.

Re: Re: Restrict access to one sheet

Thu, 13 Mar 2014 17:43:04 GMT

sorrry where is the enable hidden sheet and which attachment

Re: Restrict access to one sheet

Carlos_Reyes — Thu, 13 Mar 2014 17:46:52 GMT

I enclosed a file in my last responde. If you can't see it perhaps you can try with a different internet browser. You'll need a Developer QlikView license to open that file, if you don't have one it'll be difficult to explain how to do replicate this option.

Regards!