Sense Excel, the Add-In for Microsoft
If you miss something please send us an email. Thanks!
Security Rules for Qlik Sense
Add rule for
Add this rule to allow the user to make QRS API calls needed to deliver the reports.
Setting | Value |
Name | AG_User |
Resource filter | User* |
Conditions | ((user.id=resource.id)) |
Context | Both in hub and QMC |

These settings concern the HUB distribution.
If you are a normal Qlik user then use this security rule to allowed and distribute to HUB.
Add Shared Content Rule
Setting | Value |
Name | AG_Shared_Content |
Resource filter | SharedContent* |
Conditions | ((user.name=resource.owner)) |
Context | Both in hub and QMC |

If you add this rule, no one can see the reports of other users. This rule allows all users to access the Shared Content section to create or delete their own reports.
Block Anonymous Shared Content User
Setting | Value |
Name | AG_On_Demand |
Resource filter | SharedContent* |
Conditions | !user.IsAnonymous() |
Context | Both in hub and QMC |

Add Rule for AnalyticsGate License
This rule allows read access to the AnlayticsGate licence in the content library.
Setting | Value |
Name | AG_License |
Resource filter | License_* |
Conditions | !user.IsAnonymous() |
Context | Both in hub and QMC |

Add Rule to Read the “SER” Tag in the QMC
Example: “!user.IsAnonymous() and (resource.id=”ABC-1234-ABC-1234-ABC-1234-ABC-1234” or resource.id=”ABC-1234-ABC-1234-ABC-1234-ABC-1234“)”
Setting | Value |
Name | AG_Tag |
Resource filter | Tag_* |
Conditions | ((!user.IsAnonymous() and resource.id=”add the ID from SER Tag”)) |
Context | Both in hub and QMC |

Add Rule for Scheduler
If you want to enable the automation of Reporting please add this rule in Qlik Sense.
Setting | Value |
Name | AG_Scheduler |
Resource filter | App_* |
Conditions | ((user.name=”ser_scheduler” and user.userDirectory=”INTERNAL”)) |
Context | Both in hub and QMC |

No Comments