Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
ali_hijazi
Partner - Master II
Partner - Master II

Security Rule to hide base sheet

Hello got a QVF file named Finance P&L Dashboards
in this file I got a base sheet named DB_TIMES
I want to hide this sheet temporarily for all users
I created the below security rule:

ali_hijazi_0-1691069483867.png

but I'm still able to see the sheet if I open the dashboard from the hub

I can walk on water when it freezes
Labels (1)
9 Replies
Or
MVP
MVP

Presumably, there's another rule (perhaps one of the default rules) that allows access to this sheet? You can't actually create exclusion rules, only inclusion rules, so if this rule includes every sheet except one and that one is still showing, a different rule is most likely to be at play. 

Aurelien_Martinez
Partner - Specialist II
Partner - Specialist II

Hi,

To add to @Or 

You can see the rule called "Stream" (The user should see the resource if he/she has read access to the stream it is published to) 

 

But a simple way to achive this is the Show/Hide condition in the sheet.

Help users find answers! Don't forget to mark a solution that worked for you!
Or
MVP
MVP


But a simple way to achive this is the Show/Hide condition in the sheet.

This does not act as security. Users with the right to duplicate / create sheets will be able to access the hidden sheet by making a copy of it.

ali_hijazi
Partner - Master II
Partner - Master II
Author

so how can I hide this sheet from the users using a security rule?

I can walk on water when it freezes
Aurelien_Martinez
Partner - Specialist II
Partner - Specialist II

You right ^^

 

It depending on risk you can take. Changing security rule can be tricky 😐

 

Another solution can be to unpublish and unapprove sheet. The sheet still exist but only the owner can see it.

Help users find answers! Don't forget to mark a solution that worked for you!
Aurelien_Martinez
Partner - Specialist II
Partner - Specialist II

I have found this

https://community.qlik.com/t5/New-to-Qlik-Sense/Sheet-level-Section-Access-in-Qlik-Sense/td-p/789067

Help users find answers! Don't forget to mark a solution that worked for you!
Or
MVP
MVP

You will need to find the security rule(s) that enable access to sheets and disable them. I'd suggest you be careful about this and do it in a test environment first to make sure you aren't breaking anything important.

I think the default rule in question is covered here, section 4.1:

https://community.qlik.com/t5/Qlik-Sense-Documents/Sheet-or-App-Object-Level-Security-Qlik-Sense/ta-...

ali_hijazi
Partner - Master II
Partner - Master II
Author

Several discussions point to this article which is unclear 
and it is about giving access to stream 
anyways it seems this is a very vague / complicated issue

 

 

I can walk on water when it freezes
Or
MVP
MVP

Perhaps, but then again, a security rule hiding a single sheet is a pretty obscure issue, so it stands to reason there's no clear and easy way to do it a the click of a button. You can use show/hide conditions as suggested by @Aurelien_Martinez  if you want a simple approach.