Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Sheet Security

I have seen other post on this topic and they are not correct and or misleading.  Is there currently away in Sense 3.1 to hide a sheet in an application so normal users cannot see it?  The read privileged would be only for a Root admin, just to keep it simple.

8 Replies
p_verkooijen
Valued Contributor

Re: Sheet Security

Take a look at reddys310 answer in Sheet level security qliksense

Replace the (resource.name = "Sheet1") with (resource.name != "<SheetID>")

Note: you can get the sheet ID from the the single configuration tab in the DEV-HUB

Replace the(user.name = "user1") with (user.name = "<UserID>")


This will actually restrict a user from viewing a particular sheet

kevincase
Contributor II

Re: Sheet Security

Sean,

Yes you can add sheet security.

What you want to do is create a rule that grants read access to a sheet where the name = your_sheet_name and user.roles="RootAdmin"

I would be reluctant to implement sheet security as I think it would require constant maintenance as your environment changes and/or sheet names change.  I also think people may be reluctant to answer and give you an exact rule as everyone's environments have different security rules implemented.

Something like this may work.  You just have to experiment a little.  In this example, it grants read access to the Performance Figures sheet only if your role is RootAdmin.

Hope this helps.

Kevin

Not applicable

Re: Sheet Security

Not having much luck. Is there a default rule that allows access to sheets that may be interfering?

Sean Smith

Consultant

N27 W23957 Paul Road, Suite 100, Pewaukee, WI 53072

262.751.5193

sean.smith@solve100.com<mailto:sean.smith@solve100.com>

www.Solve100.com<http://www.solve100.com/>

Not applicable

Re: Sheet Security

Is this a typo, resource.name != "

kevincase
Contributor II

Re: Sheet Security

Sean,

If you are a root admin, you my not be able to test the rule as this rule may override your new rule.  You would need a test user that you can connect with that does not have the root admin role.

Not applicable

Re: Sheet Security

I do have another login that I am using for testing and that user can still see the sheet. Ant other thoughts? Have you been able to get this to work?

Sean Smith

Consultant

N27 W23957 Paul Road, Suite 100, Pewaukee, WI 53072

262.751.5193

sean.smith@solve100.com<mailto:sean.smith@solve100.com>

www.Solve100.com<http://www.solve100.com/>

kevincase
Contributor II

Re: Sheet Security

Sean,

I did not get it to work.  I would suggest opening a ticket with support.  If I have time on Monday, I'll give it another try.  I'm missing something and its late on a Friday!

Not applicable

Re: Sheet Security

Totally understand thanks let me know

Sean Smith

Consultant

Solve

N27W23957 Paul Rd

Suite 100

Pewaukee, WI 53072

262.751.5193

www.Solve100.com<http://www.solve100.com/>

Community Browser