test for a blank sheet description in a security rule

[mstoler]

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=""

[Levi_Turner · Accepted solution]

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.

[mstoler]

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