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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Access denied to this Qlikview document.

In my load script, I have the following:

Section Access;

Load * inline [

USERID, PASSWORD, ACCESS, GROUPNAME

bloggsj jb,USER,G1

smithj,js,USER,G2

admin,1,ADMIN,*

];

Section Application;

Star is *;

Groups:

load * inline [

GROUPNAME

G1

G2

];

Then in a textbox property, I have the following condition

=FieldIndex('GROUPNAME', 'G1')

meaning I only want to see bloggsj and Admin to be able to see that textbox.

When smithj tried to log in though, he gets Access denied to this Qliviview document.

I have both Initial Data Reduction Based On Section Access and Strict Exlusion checked. If I remove one or both of these, access is accepted but smithj can then see the textbox.

Any suggestions?

2 Replies
stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

If you've ever locked yourself out of your QlikView document - or want to make sure you avoid locking yourself out, you may want to read this:

http://www.quickintelligence.co.uk/help-ive-locked-myself-out/

Steve

maxgro
MVP
MVP

there is a missing comma in this line

bloggsj jb,USER,G1


but your script for me works