topic Re: Section Access Issue Sheet level security in QlikView

Section Access Issue Sheet level security

kakani87 — Mon, 19 Feb 2018 12:40:44 GMT

Hi Everyone .... here i'm not able to implement sectuion access sheet level

Reqirement is to restrict admin both SH1 and SH2 to access, ajith only SH1 and Sai only SH2

When user is logged as 'Sai' then it is not restricting accordingly

Following is my script and Attachment of File as well so do me favour in implementing this successfully.

USER, AJITH, 123

USER, SAI, 123

ADMIN, ADMIN, 123

SECTION Access;

ACCESS:

load * Inline

[

ACCESS, USERID, PASSWORD, EMPCODE

USER, AJITH, 123, 1

USER, SAI, 123, 2

ADMIN, ADMIN, 123, *

];

SECTION Application;

EMPMST:

LOAD * Inline

[

EMPCODE,EMPNAME

1,AJITH

2,SAI

3,ADMIN

];

TAB_ACCESS:

load * Inline

[

EMPCODE,TAB1,TAB2

1,1,0

2,0,1

]

;

SALE:

load * Inline

[

EMPCODE,QTY,VALUE

1,10,100

1,2,20

2,1,10

2,2,20

];

Re: Section Access Issue Sheet level security

jaumecf23 — Mon, 19 Feb 2018 13:55:30 GMT

I have attached a pdf document that can help you.

Re: Section Access Issue Sheet level security

stigchel — Mon, 19 Feb 2018 13:58:38 GMT

There is a setting in the document properties you need to deselect, see attached qvw that does hide the sheets...

Re: Section Access Issue Sheet level security

passionate — Mon, 19 Feb 2018 14:50:09 GMT

Hi Kakani,

instead of using tabaccess use conditional hide and show in sheets.

PFA.

Please let me know for more information.

Cheers,

Panka

Re: Section Access Issue Sheet level security

kakani87 — Tue, 20 Feb 2018 07:10:11 GMT

Hi Piet .... this worked thank you very much

Re: Section Access Issue Sheet level security

kakani87 — Tue, 20 Feb 2018 07:23:05 GMT

Hi Pankaj ... Thank you for the work done by you

After making change in conditional as =TAB1 and =TAB2 this as well working fine .

Re: Section Access Issue Sheet level security

kakani87 — Tue, 20 Feb 2018 07:24:02 GMT

Piet and Pankaj let me thank you both for resolving this issue