Hi All, Is it possible in Qlikview to restrict an user to a particular Tab. For example, suppose there is a tab known as 'USER TAB' which displays various charts of Opened and Closed tickets by the Users Vs Month,etc. Now if a user logs in with his creden

[asifmaula2015]

Hi All,

Is it possible in Qlikview to restrict an user to a particular Tab.

For example, suppose there is a tab known as 'USER TAB' which displays various charts of Opened and Closed tickets by the Users Vs Month,etc. Now if a user logs in with his credentials, he should ONLY see the data corresponding to his own ID in the 'USER TAB'. But at the same time he should be able to view all other tabs like any other user,

Awaiting your replies!

Thanking in Advance!

--Asif

[jaimeaguilar]

Hi,

you may want to take a look at this document, I think it explains what you need:

https://community.qlik.com/docs/DOC-5175

regards

[robert99]

hi

I have done it this way

By using sheet properties conditional

Sheet Properties Conditional

[krishna_2644]

yes, you can restrict a user to see only his/her concerned data/charts/tabs.

This can be achieved with the help of section access.

Something like below.

Section Access;

STAR IS *;

LOAD

    ACCESS,

//    USERNAME AS NTNAME,

//    PASSWORD,

USERID

RESIDENT ACCESS;

Section Application

you can show hide tabs for particular user:

Rt click on tab-->Sheet Properties-->General -->check 'Conditional' --> write this if statement

'=if(QVUser()='USERID',1,0)'

let me know if you have any questions.

Thanks

[Bill_Britt]

Hi,

Here is a example.

Section Access;

Security:

LOAD * INLINE [

    ACCESS, USERID, SHEET

    ADMIN,SERVICEACCOUNT,

    ADMIN, ADMIN, *

    USER, USER1, A

    USER, USER2, B

    USER, USER3, C

];

Section Application;

SheetAccess:

LOAD * INLINE [

    SHEET, SHEET1FLAG, SHEET2FLAG,SHEET3FLAG

    A, 1, 0, 0

    B, 1, 0, 1

    C, 1, 1, 1

];

!