Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
kakani87
Specialist
Specialist

Section Access Issue Sheet level security

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

];

!

1 Solution

Accepted Solutions
stigchel
Partner - Master
Partner - Master

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

ShowSheetObjects.png

View solution in original post

6 Replies
jaumecf23
Creator III
Creator III

I have attached a pdf document that can help you.

stigchel
Partner - Master
Partner - Master

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

ShowSheetObjects.png

passionate
Specialist
Specialist

Hi Kakani,

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

PFA.

Please let me know for more information.

Cheers,

Panka

kakani87
Specialist
Specialist
Author

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

kakani87
Specialist
Specialist
Author

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

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

kakani87
Specialist
Specialist
Author

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