Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

test for a blank sheet description in a security rule

Hello,

I need to test for a blank description for a sheet in a Qlik Sense Dashboard in a security rule

I am going to use this below but I was wondering if anyone else has any other solutions.

Thank You,

Michael

resource.objectType = "sheet" and resource.description=""

1 Solution

Accepted Solutions
Highlighted
Employee
Employee

Re: test for a blank sheet description in a security rule

It's not entirely clear what you're trying to do, although I suspect it's something about sub-app level security rules and you're trying to have a catch all rule if a specially crafted phrase or word is not present. A bit more clarity on the use case would be helpful.

In any case, without doing testing on things, I'd first explore the Empty operator.

View solution in original post

2 Replies
Highlighted
Employee
Employee

Re: test for a blank sheet description in a security rule

It's not entirely clear what you're trying to do, although I suspect it's something about sub-app level security rules and you're trying to have a catch all rule if a specially crafted phrase or word is not present. A bit more clarity on the use case would be helpful.

In any case, without doing testing on things, I'd first explore the Empty operator.

View solution in original post

Highlighted
Partner
Partner

Re: test for a blank sheet description in a security rule

Hello,

Thank you for getting back to me.  

I am working on creating security rules to allow me to hide sheets in a Qlik Sense Dashboard.

The idea I have is to use the description field to indicate if the sheet is visible or now.  If the description field is blank (empty) then the sheet is always visible.

If there is value in the field then I want to compare the value to a custom field on the user and if they are equal show the sheet.

I am doing this because there are no custom properties for a sheet.   I have found the empty() does not work on the description field but comparing to "" does work.

Thank You,

Michael