Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
joachim_boivie
Partner - Contributor III
Partner - Contributor III

Problem with section access

Hi,

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)

Section Access;

LOAD * INLINE [

    ACCESS, NTNAME, NTDOMAINSID, COUNTRYCODE

    ADMIN, mydomain\qlikview.admin, S-X-Y-ZZ-XXXX-ZZZZZZ-YYYYYYYYYYYY-XXXXXXXXXXXXX,

];

Concatenate

LOAD

    UPPER([ACCESS]) AS ACCESS,

    UPPER(NTNAME) AS NTNAME,

    UPPER(S-X-Y-ZZ-XXXX-ZZZZZZ-YYYYYYYYYYYY-XXXXXXXXXXXXX') as NTDOMAINSID,

    UPPER(COUNTRYCODE) AS COUNTRYCODE

FROM

[..\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.

Any ideas?

0 Replies