Discussion Board for collaboration on QlikView Security and Governance.
I try to apply section access to sheet level. Please look on attached QVW. The code does not work if I load section access from excel.
The code will work if I load inline but cannot publish to upfront.
Can anybody help me on this issue?
Thank you very much in advance.
Go to Solution.
I used this, no upper and I replaced the field USERID with FIELD (in excel too)
Also in menù --> settimgs --> document properties --> opening I checked Initial data reduction..... and Strict Exclusion
(ooxml, embedded labels, table is Access);
LOAD upper(FIELD) as FIELD ,
(ooxml, embedded labels, table is Page);
I'm not able to open the doc, because of section access (access denied)
Please see attached code. It's using NTName and will block out access. I comment this code. Un-comment and reload to see.
Let me know if you have any idea.
Thank you - Maxgo.
Can you upload this qvw again. I cannot open this file.
Your code is working but I cannot publish this testing qvw to upfront. I got this error:
(2015-11-17 16:06:52) Error: The document failed to open. Bad Username and password is the most likely cause of this problem.
Do you think where I need setup this username and password? Currently, I set myself as admin but I cannot publish.
Thank you very much.
I add program domain admin name to it and it can publish now.
Thank you very much -- Maxgro.