Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Try this:
Section Access;
load * inline[
ACCESS, USERID, PASSWORD
ADMIN, ADMIN, ADMIN
USER, USER1, U1
USER, USER2, U2
];
Section Application;;
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
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
Thank u so much !
i added a space and Section application and the script works!
Yep !
it worked as your advice~!
thank you so much!
Thank u!
it works~!!
Ok, i'll try it ~~
thank u