Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problems with Section Access

I'm playing around with inline section access to test out functionality.  I'm having trouble logging in with USERs.  ADMINs just fine.

here is my code:

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD

    ADMIN, ADMIN, ADMINPWD

    USER, BOB, BOBPWD

];

Section Application;

LOAD * INLINE [

USERID, Representative

BOB, BOB

];

When opening the document using the admin user, it opens just fine.  If I try to use a USER userid, I get "Access denied to this Qlikview document"

Anyone know what I'm doing wrong?  I have reloaded after adding. I have "Initial Data Redectuion Based on Section Access" and "Strict Exclusion" checked.

24 Replies
IAMDV
Master II
Master II

You are welcome Nigel. Also, remember the reduction field name can be in mixed or lower case but the field values should be in upper case. This applies to the Section Access Reduction Field & also original Field Values. I had provided detailed explanation in the above link with sample script.

I hope this makes sense!

Cheers,

DV

www.QlikShare.com

Not applicable
Author

I read that document 3 times. Can I suggest you BOLD that section? I totally missed it. Maybe just me.

IAMDV
Master II
Master II

We are sailing in the same boat. I had done the same few times...

Cheers,

DV

www.QlikShare.com

Not applicable
Author

I've been using QlikView for 6 years, 5 of those have been spent feeling

like an idiot, welcome to the party.....

IAMDV
Master II
Master II

Sure. Which section are you talking about? Please can you send the screenshot?