Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I am facing an issue in Sheet level section access
I have done the following steps:
STEP1: wrote script like below:
SECTION ACCESS;
LOAD * INLINE
[
ACCESS,NTNAME,GROUP
ADMIN, QLIKID,ALL
ADMIN,MYNTNAME,GRP
USER,SPECIFICID,GRP1
];
SECTION APPLICATION;
SHEET_ACCESS:
LOAD *INLINE
[
GROUP, SH01,SH02
ALL,1,1,
GRP,1,1,
GRP1,1,0
];
STEP 2: enabled strict exclusion in document properties
STEP3: also wrote conditional hiding in sheets like (SH01=1 etc)
After reload the file and saved. When i am checking the file in local it is working for me and other users as well.
But after published the same application in access point, i am getting the error when i tried to open the file.
failed to open the document. you don't have access to this document.
Note: When i wrote the same NT name for Data level security it is working in access point. Only sheet level is not working
Can any one please advice is there any step i am missing . please help me to solve this issue.
Thanks and Regards,
Uma.k
If the application is not reloaded with all data, you may be eventually opening a file with no sheets, and the error could be because of that.
Test first that row level security works, then check the conditions for the sheet.
Note that
SH01 = 1
will be false if the same user has more than one different value, so instead use something like
Max(SH01) = 1
or similarly suitable function.
Think of what is the difference between local and server, different account names, headers, etc.
May be you can use Fieldindex('Field Name', 'Compare Value')>0 in conditional statement.
Uma, have a look at the following Design Blog post, and note there are further links at the bottom of that post too. Hopefully this may give you some further help/ideas on how to go about things in your use case.
https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Section-Access/ba-p/1465766
Regards,
Brett