Skip to main content
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