topic Re: Access Section syntax error in QlikView

Access Section syntax error

Mon, 26 Jan 2026 18:19:17 GMT

Dear experts,

Recently I'm learning Qlikview by myself. Today when i practise Access Section, I found an error when i click the reload button while the hidden scrpit is editted.

I just want to establish two members, one is admin and the other is user. I click the reload after finishing coding.(I'm not sure whether this process is correct). and an error message occurred and told that:

the chinese said that an syntax error occurred and 'From' is missing or at wrong place.

Could anyone help me on this issue~~

Many thanks and thanks in advance!!

br,

Lisen

Re: Access Section syntax error

tresB — Wed, 07 Jan 2015 09:10:11 GMT

A semi colon is possibly missing. Try like:

Section Access;

Load

* ; // this semi colon is required

// This extar load might not be required if there is no such modification to inline load

Load * Inline [

...

];

Re: Access Section syntax error

giakoum — Wed, 07 Jan 2015 09:11:00 GMT

please copy your whole script here

Re: Access Section syntax error

Wed, 07 Jan 2015 09:21:22 GMT

OK, I'll try this method~

thanks very much:)

Re: Access Section syntax error

Wed, 07 Jan 2015 09:21:47 GMT

just a very simple code:

SECTION

Access;
load * inline[
ACCESS, USERID, PASSWORD
ADMIN, ADMIN, ADMIN
USER, USER1, U1
USER, USER2, U2
];

Re: Access Section syntax error

Wed, 07 Jan 2015 09:24:16 GMT

I've tried this semi colon...but sadly it failed again...

but i'm still appreciate for your reply~

Re: Access Section syntax error

giakoum — Wed, 07 Jan 2015 09:26:14 GMT

THIS WORKS

SECTION Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD

ADMIN, ADMIN, ADMIN

USER, USER1, U1

USER, USER2, U2

];

SECTION Application;

Re: Access Section syntax error

tresB — Wed, 07 Jan 2015 09:29:56 GMT

Try inserting a space between the keyword Inline and '[' like:

load * inline [

Re: Access Section syntax error

Wed, 07 Jan 2015 09:31:12 GMT

sorry man...it failed due to same error...

did i miss some script or some configuration is not correct?

Re: Access Section syntax error

giakoum — Wed, 07 Jan 2015 09:35:52 GMT

this is the exact same code and it works in Qv11.20Sr1

Try it out

Re: Access Section syntax error

Wed, 07 Jan 2015 09:42:19 GMT

Hi Lisen,

the syntax is like this:

if u are hard coding it in your script, the:

Section Access;

Load * inline[

ACCESS, USERID, PASSWORD
ADMIN, ADMIN, ADMIN
USER, USER1, U1

];

Section Application;

Load * inline[

\\ here on section application please state which user has to c what information, for example an administrator

in most cases has access to all your data, but certain users has restriction, suppose u have a table with column Gender, and u want User1 to only see Male. Then you will have the following.

USERID,Gender

ADMIN,*

USER1,'Male'

];

hope this helps

Re: Access Section syntax error

alkesh_sharma — Wed, 07 Jan 2015 09:45:00 GMT

Try this:

Section Access;
load * inline[
ACCESS, USERID, PASSWORD
ADMIN, ADMIN, ADMIN
USER, USER1, U1
USER, USER2, U2
];

Section Application;;

Re: Access Section syntax error

Peter_Cammaert — Wed, 07 Jan 2015 10:51:54 GMT

If I copy the exact syntax of your script (SECTION and ACCESS on different lines, no space between INLINE and [), I get the same error as you do.

If I then insert a space between INLINE and [, the script runs to completion. Tres is right.

Peter

Re: Access Section syntax error

Wed, 07 Jan 2015 11:21:27 GMT

Lisen

Can you create an excel file with this

ACCESS, USERID, PASSWORD
ADMIN, ADMIN, ADMIN
USER, USER1, U1
USER, USER2, U2,

then in your script, instead of load * inline, load it from excel, just to verify where the problem is, because load inline doesn't require a 'from' statement that is complaining about.

Regards

Re: Access Section syntax error

Thu, 08 Jan 2015 01:31:29 GMT

Thank u so much !

i added a space and Section application and the script works!

Re: Access Section syntax error

Thu, 08 Jan 2015 01:32:23 GMT

Yep !

it worked as your advice~!

thank you so much!

Re: Access Section syntax error

Thu, 08 Jan 2015 01:33:23 GMT

Thank u!

it works~!!

Re: Access Section syntax error

Thu, 08 Jan 2015 01:33:51 GMT

Ok, i'll try it ~~

thank u