Section Access

[smilingjohn]

Hi All , 

I wanted to know how do i create a section Access using NT name ..  Users access the application thorugh Access Point 
at sheet level . ( i don't want to assign the users password , it should happen through there NT name user id and password )
Can someone please help with the steps

Tahnks in Advance

[martinpohl]

create a new sheet

go to tab general of the tab

edit show condition

=match(upper(osuser()),'DOMAIN\USER1','DOMAIN\USER2')

Regards

[smilingjohn]

Hi Martinphol

Thanls for the reply .I really did not understood , can you please give me one example it will be really helpfull for me . 

I have never created a section access beofre . Users are access the developed dashboard trough Access Point .

Tahnks 

[martinpohl]

I didn't meant to realize sheet access by section access.

for that

section access;

load * inline [

ACCESS, NTNAME, SHEET

ADMIN, DOMAIN\USER1, A

ADMIN, DOMAIN\USER2, A

ADMIN, DOMAIN\USER2, B

];

section application,

on the sheet, show condition

=substringcount(SHEET,'B') = 1

also enable on tab open under document properties reduce data on opening using section access

Remember that it only works after opening the sheet. after reload all datas for all users are in.

Also, don't forget to add service account to reload application

Regards

[smilingjohn]

Hi Martinpohl,

What is service account ? 

Within the script I need to add only this much right ? and change my domain . Can i also give SHeet ,1,2,3,4,?

section access;

load * inline [

ACCESS, NTNAME, SHEET

ADMIN, DOMAIN\USER1, A

ADMIN, DOMAIN\USER2, A

ADMIN, DOMAIN\USER2, B

];

Thanks 

[Brett_Bleess]

John, see the below links, pretty sure they should get you well on your way:

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Section-Access/ba-p/1465766

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Security.htm

Regards,
Brett