Hi, we are changing our document from using solely an excel sheet for section access to using a combined excel and database. The reason for this is that we need local developers to have access as well as the users externally.
The code I have in loading the section access is
Section Access;
LOAD
COMPANYCODE,
NTNAME,
Upper(trim ("SCOPE")) as SCOPE,
Upper(trim( "ACCESS_")) as ACCESS,
SURNAME,
FORENAME
;
SQL SELECT *
FROM "CT_PORTAL_UAT_DUP1".QVSECTIONACCESS
;
Concatenate
LOAD NTNAME,
upper(trim(SCOPE)) as SCOPE,
ACCESS as ACCESS
FROM
[..\New_Qlikview_Live\Shared\Source\Security\Qlikview Access_XX_ONLY_test.xlsx]
(ooxml, embedded labels, table is Sheet3);
Section Application;
When we test a user logging in tot he external portal that is listed in excel, they authenticate straight away, however the user logging in who is in the database gets a lo in pop up box.
Do you think it is the Qlikview document or setting, or do you think it is connected to the external authentication.
Any advise would be appreciated