Discussion Board for collaboration on QlikView Scripting.
i was running section access on QV 10 SR1 and upgraded to SR3 (and also a new environment). Now it has stopped working.
I do the following, (for reducing countrycode for specific users)
LOAD * INLINE [
ACCESS, NTNAME, NTDOMAINSID, COUNTRYCODE
ADMIN, mydomain\qlikview.admin, S-X-Y-ZZ-XXXX-ZZZZZZ-YYYYYYYYYYYY-XXXXXXXXXXXXX,
UPPER([ACCESS]) AS ACCESS,
UPPER(NTNAME) AS NTNAME,
UPPER(S-X-Y-ZZ-XXXX-ZZZZZZ-YYYYYYYYYYYY-XXXXXXXXXXXXX') as NTDOMAINSID,
UPPER(COUNTRYCODE) AS COUNTRYCODE
[..\1. Data source\SectionAccess.xls]
(biff, embedded labels, table is [sectionaccess$]);
But as I wrote above, this code is not working. If I trying to open the document as a user from the xls file I will be denied access.