topic Section Access in QlikView

Section Access

Mon, 28 Feb 2011 11:11:10 GMT

Hi,

I am trying to reduce the data based on the user logged in . Qvw file is not even prompting for the username and password.

Please find the below script.

User Table:

Username Password Access CID

User1 user1 user c1

User2 user2 user c2

User3 user3 user c3

User4 user4 user c4

Admin Admin Admin *

Section Access;

Load

Username, Password, Access, CID

from table1;

Section Application;

Load

Username, Password, Access, CID

from table1;

I have enabled the Initial Data reduction based on the section Access.

Strict exclusion.

I am not sure why it is not prompting for user name and password.

Re. :Section Access

martin59 — Mon, 28 Feb 2011 11:26:00 GMT

Hi,

Your fields have to be in uppercase and you have to rename them like this :

LOAD ACCESS, USERID, PASSWORD, ... FROM Table1;

In the ACCESS field, you have to enter these values : ADMIN or USER

Hope it helps you.

Section Access

prieper — Mon, 28 Feb 2011 11:42:06 GMT

You need to observe instructions regarding use of capital letters and need to insert "STAR IS"-command.

SECTION ACCESS;
 STAR IS *;
 Table1:
 LOAD
 *
 INLINE
 [USERID, PASSWORD, ACCESS, CID
 User1, user1, USER, c1
 User2, user2, USER, c2
 User3, user3, USER, c3
 User4, user4, USER, c4
 Admin, Admin, ADMIN, *];
 SECTION APPLICATION;
Data:
 NOCONCATENATE LOAD * RESIDENT Table1;

HTH
Peter

Section Access

Mon, 28 Feb 2011 13:24:02 GMT

Hi Peter and Martin,

Thanks for your response. Now the funniest thing is it is prompting only for the Password.

And i am not able to access the file itself.

Any way to resolve this...

Section Access

prieper — Mon, 28 Feb 2011 21:19:08 GMT

Continue with the backup-copy ....

Peter

Section Access

Tue, 01 Mar 2011 04:27:17 GMT

That is the disappointment because i dont have the backup.Want to know when it will prompt only the password.At what scenario

Section Access

Tue, 01 Mar 2011 06:17:23 GMT

Hi Peter,

I found the reason why it is prompting only the Password and i have fixed the issue.Thanks for your support

Section Access

Tue, 01 Mar 2011 07:03:34 GMT

can you tell me the scenario....

what is the reason it was prompted only password....

Section Access

Tue, 01 Mar 2011 07:19:31 GMT

I was using like this

User Table:

Username Password Access CID

So it was prompting me only the Password in section Access. it was the username Caused the problem. It should be Userid.Once i changed to userid it is working fine.