topic Re: Got error creating user Section Access in QlikView

Got error creating user Section Access

Sat, 20 Sep 2014 20:11:53 GMT

Hello,

Am trying to restrict my users to see specific sheet but not working plz find attached what could be wrong?

Rgds

Ema

Anonymous — Sat, 20 Sep 2014 20:59:31 GMT

look a this sample attached

ADMIN,123

USER1,123

USER2,123

USER3,123

Sat, 20 Sep 2014 21:00:23 GMT

Can you copy paste your script here, can't open qvw file.

Anonymous — Sat, 20 Sep 2014 21:15:17 GMT

you can open it with ADMIN user and 123 password

Anonymous — Sat, 20 Sep 2014 21:20:16 GMT

here is your file modified

and make sure you have no selected "Show All Sheets and Objects"

satishkurra — Sat, 20 Sep 2014 23:11:55 GMT

Please use the below navigation.

1. EDIT SCRIPT , paste the below

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD

ADMIN, admin, admin

USER, user1, user1

USER, user2, user2

];

Section Application;

2. Reload

3. Make sure u uncheck Settings -> User Preferences -> uncheck "Remember Login Cedentials Until Qlikview Exists"

4. Settings -> Document Properties -> Opening Tab -> Check Initial Data Reduction Based on Section Access and Strict Exclusion

5. APPLY -> OK

6. CREATE new sheets say sheet1 for user1 and sheet2 for user2

7. Go to individual sheet properties and in general tab specify under show sheet select Conditional and specify as

=QVUser()='ADMIN' or QVUser()='USER1' -----> For sheet1

8. Perform same for sheet 2 as specify as

=QVUser()='ADMIN' or QVUser()='USER2' -----> For sheet2

9. Close and reopen document and now u see with ADMIN, will see all sheets and with USER1 u see main and sheet1 and with USER2 u see main and sheet2

Let me know if u face any issues

Thanks

Satish