Discussion Board for collaboration related to Creating Analytics for QlikView.
I have applied section access to my qlikview document.
i have applied row level security.
i have one list box by name 'flag', and i have created inline userid and password.
below is the section access script which i have used
LOAD * INLINE [
ACCESS, USERID, PASSWORD
Admin, abroker, abroker
User, acost, acost
User, breed, breed
User, brotter, brotter
User, samo, samo
LOAD * Inline [
when i save and open the document by using some user credentials like acost and acost, then am getting this error 'Access Denied to this QlikView Document'.
i dont know why am getting this error. i saw some video about security in qlikview community and implemented same, but also am getting this error.
am using qlikview 11.
can anyone help me out in this issue?
Go to Solution.
It should be like this...
ADMIN, ABROKER, ABROKER
USER, ACOST, ACOST
Try changing the syntax so it is all in upper case in the section access area..
This may help
Thanks for reply,
which one you want me to change the syntax?
which one i need to change it in Upper case?
But i have Userid's getting from Database field, those names are in lower case.
so will it affect these uppercase names?
I don't believe so, from memory I don't think mine was affected by the difference in syntax.... however make sure you back up before testing it..
If there is an issue with it just place the upper formula before the load when you bring in the application table.
thanks for the help, its working fine after changing everything to uppercase.
I'm glad it helped
its a shame you had to change everything though...
but thanks for the great help