Section Access problem when using external log in via Redhat / Lifray

Fri, 07 Aug 2015 11:17:49 GMT

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

topic Section Access problem when using external log in via Redhat / Lifray in QlikView

Section Access problem when using external log in via Redhat / Lifray