Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
agigliotti
Not applicable

Qlik Sense - security rules to manage single sheets showing

Hello,

My requirement is to show only 4-5 sheets of 30 total.

Below the security rule I'm using for specific users that works fine:

Resource filter: App.Object_*,Stream_5666088f-c4de-4f2c-88aa-d5ea4b1b19a1

((user.userDirectory="AM" and resource.app.name="Sales analysis" and resource.name!="Agenti Top Performer" and resource.name!="Analisi dei sospesi e blocchi" and resource.name!="FATT vs MARG LORDO" and resource.name!="ANALISI GEOGRAFICA" and resource.name!="Relazioni" and resource.name!="Fatt vs MARG comparativo" and resource.name!="KPI AREA" and resource.name!="TEST for support" and resource.name!="TEST for support (1)" and resource.approved="true" and resource.name!="CRM"))

I'd need to add another security rule for all users belongs to userDirectory="SF" to enable them to see only the following sheets names:

- "Agenti Top Performer"

- "Analisi dei sospesi e blocchi"


I know I could use the same rule as above with all sheets names they can't see but I'd like to use the reverse logic I mean listing only the sheets they can access to like below:


Resource filter: App.Object_*

((user.userDirectory="SF" and resource.app.name="Sales analysis" and resource.name="CRM" and resource.approved="true"))

Using this security rule I noted I can't see Master Items anymore. Why ?

Also I'd like to know if is possible to use Tags within security rule in order to avoid to list all sheets name.

Could someone suggest me the quickest way to enable users to show only some sheets (with Master Items) with security rule ?

Attached all rules I disabled if can help.

Many thanks in advance.

Best Regards

Tags (1)
5 Replies
rubenmarin
Not applicable

Re: Qlik Sense - security rules to manage single sheets showing

Hi Andrea, I didn't tested but seems it restricts access to any other object that doesn't have 'CRM' as name, so master items without this name can't be seen.

Maybe adding a condition to ignore this condition when the object is not a Sheet, like:

or resource.resourcetype!="Sheet"

Last time I tested I can't assign custom properties to app objects, would be nice to have this option available to avoid using sheet names, you can use a prefix or suffix to group them.

agigliotti
Not applicable

Re: Qlik Sense - security rules to manage single sheets showing

Hi Ruben,

Do you know if is possible to use Tags within security rule ?

This could be useful in this case because as you can see below I associated two sheets to "INTERNAL_USE" tag

name and I'd like to use it inside security rules rather than sheets names.

Image 5.png

rubenmarin
Not applicable

Re: Qlik Sense - security rules to manage single sheets showing

Hi Andrea, Tag is listed as available resource, have you tried to use it?

https://help.qlik.com/en-US/sense/June2017/Subsystems/ManagementConsole/Content/available-resource-f...

I can't test it, but you can try to detect tags with:

resource.resourcetype="Tag"

agigliotti
Not applicable

Re: Qlik Sense - security rules to manage single sheets showing

I gave a try quickly but seems it doesn't works.

When I try to set value for resource type no values are available.

agigliotti
Not applicable

Re: Qlik Sense - security rules to manage single sheets showing

I tried what below but it doesn't works.

Image 31.png

Before I have created a tag named "SF_USE" associated with a sheet of sales app.

How can I refer to this tag within security rule ?

Could someone help me to achieve it ? if this is possible of course.