Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
Partner
Partner

what's wrong with this script

Section Access;

LOAD  Distinct

     USER_LOGIN

   

FROM

QVDS\SILK_USER_PROJECT_DW.qvd

(qvd);

SECURITY:

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, NTNAME

    ADMIN, ALI, HIJAZI, *

];

Concatenate(SECURITY)

LOAD 'ADMIN' AS ACCESS,'*' AS USERID, '*' AS PASSWORD,'lb\' & USER_LOGIN AS NTNAME

Resident TEMP_SECURITY;

DROP Table TEMP_SECURITY;

Section Application;

I'm getting an error that says general script error

please advise

I can walk on water when it freezes
5 Replies
Highlighted

Re: what's wrong with this script

One error is here:

LOAD 'ADMIN' AS ACCESS


you do not need the single quote

Highlighted
Not applicable

Re: what's wrong with this script

Can you show the error?

Highlighted

Re: what's wrong with this script

I think QlikView simply cannot find the TEMP_SECURITY table because apparently you forgot to give the top table a name...

After Section Access; add this line:

TEMP_SECURITY:

Highlighted
Partner
Partner

Re: what's wrong with this script

NO i have to put this

it doesn't work either without single quotes

I can walk on water when it freezes
Highlighted
buzzy996
Honored Contributor II

Re: what's wrong with this script

are u having/defined this table "TEMP_SECURITY"?