Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

JustinDallas
Valued Contributor II

Section Access Befuddlement

Hello Folks,

I'm working with adding Seciton Access to  our system.  As of now, I see the OMIT clause is working as intended, but when it comes to Reduction, it's failing.  My script looks like this:

SectionAccessError2.PNG

But when I run the app in question as the user, I see this.  They still have access to where [Dest State] <> 'GA'.

SectionAccessError.PNG

What's going on here?

Any help is greatly appreciated.

1 Solution

Accepted Solutions
JustinDallas
Valued Contributor II

Re: Section Access Befuddlement

The documentation says that the field in the "Section Access" must be capitalized, but I don't think it said that the field name on the tables of interest had to be captialized too.

Once I capitalized my Table field [Dest State] => [DEST STATE], everything worked as intended.

5 Replies
rittermd
Honored Contributor

Re: Section Access Befuddlement

You might need the Domain\ in front of the user name.  Or whatever User Directory you loaded them from.  Check the QMC.

JustinDallas
Valued Contributor II

Re: Section Access Befuddlement

I've got the Domain in the redacted text.  I see the OMIT value working as intended, but I don't see the field restriction working as intended.

JustinDallas
Valued Contributor II

Re: Section Access Befuddlement

The documentation says that the field in the "Section Access" must be capitalized, but I don't think it said that the field name on the tables of interest had to be captialized too.

Once I capitalized my Table field [Dest State] => [DEST STATE], everything worked as intended.

mov
Esteemed Contributor III

Re: Section Access Befuddlement

This is a rear case where you have to mark your own reply as correct.  It is correct, and it's helpful to make the thread closed.

rittermd
Honored Contributor

Re: Section Access Befuddlement

Glad it worked for you.  The problem is that the field with caps in your inline table does not match the actual field name.  As you probably know, Qlik is case sensitive.  The field names have to match exactly.

Community Browser