topic Re: Data level section access in QlikView

Data level section access

debsahoo — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

A region field contain 50 countries . How I give one user can able to see 49 countries. I can achieve with section access writing 49 rows of same user. Plz help me to know other way to achieve this.

Re: Data level section access

Anil_Babu_Samineni — Mon, 25 Dec 2017 07:27:35 GMT

What is the prblem with Section access?

Re: Data level section access

debsahoo — Mon, 25 Dec 2017 08:41:12 GMT

How can I give data level section access to user.

Consider there is field 'Country ' have 50 countries . Some user can access 1 country and some user can access 40 countries .

Re: Data level section access

Anil_Babu_Samineni — Mon, 25 Dec 2017 12:17:50 GMT

May be QlikView Section Access Examples

Re: Data level section access

debsahoo — Mon, 25 Dec 2017 19:58:28 GMT

I tried but not working.

See the below script.

When i try to login with users, They are also able to see all region.

======================================================================

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, Region

Admin, Pat, Pat, *

User, Chris, Chris,Central

User, William, William, West

User, Sam, Sam, South

User, Erin, Erin, East

];

Section Application;

=========================================================================

Re: Data level section access

Anil_Babu_Samineni — Tue, 26 Dec 2017 01:36:34 GMT

May be attach QVW and provide the credentials then explain little more which user login and which data should be hidden. But, Initially you said that "using section access" it's working and now you are in another way..

Re: Data level section access

devarasu07 — Tue, 26 Dec 2017 02:22:00 GMT

Hi,

Section access and application restriction field should be in UPPERCASE

try to do below steps,

1) create below script

SECTION Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, REGION

ADMIN, PAT, PAT, *

USER, CHRIS, CHRIS,SOUTHEAST ASIA

USER, WILLIAM, WILLIAM, NORTH ASIA

USER, SAM, SAM, SOUTH ASIA

USER, ERIN, ERIN, MIDDLE EAST

];

SECTION Application;

Fact:

LOAD Upper(Region) as REGION, UPPER(Country) AS COUNTRY,* INLINE [

Region, Country, Sales

Southeast Asia, Brunei, 134

Southeast Asia, Cambodia, 93

Southeast Asia, East Timor, 128

Southeast Asia, Indonesia, 9

Southeast Asia, Laos, 10

Southeast Asia, Malaysia, 11

Southeast Asia, Myanmar, 13

Southeast Asia, Philippines, 80

Southeast Asia, Singapore, 3

Southeast Asia, Thailand, 34

Southeast Asia, Vietnam, 182

North Asia, China, 145

North Asia, Hong Kong, 7

North Asia, Japan, 412

North Asia, Macau, 3

North Asia, South Korea, 9

North Asia, Taiwan, 37

South Asia, India, 101

South Asia, Maldives, 3

South Asia, Sri Lanka, 3

Middle East, Bahrain, 8

Middle East, Lebanon, 17

Middle East, United Arab Emirates, 6

];

2) try to do below configuration (to apply data reduction based on the section access rule/definition)

3) uncheck "Reload" & Edit script from document properties --.security tab (to prevent reload from users) and enable check box for admin role can override security (it might useful when debug your section access)

4) always remember to take backup of every new changes on the section access, (once it's locked /failed to open due to section access script then u might lost your app. )

5) after try to close your qvw file then re-open then it will prompt user ID and password.

here you can try with below user and test their access rights

PAT, PAT, * // he can see all data (i.e: all region) and edit script and reload option

CHRIS, CHRIS,SOUTHEAST ASIA // he can able to see only Southeast asia country data

WILLIAM, WILLIAM, NORTH ASIA // he can able to see only north Asia country data

SAM, SAM, SOUTH ASIA // he can able to see only south Asia country data

ERIN, ERIN, MIDDLE EAST // he can able to see only middle east country data

Note: for more Refer to the attached sample.

Thanks,

Deva

Re: Data level section access

debsahoo — Tue, 26 Dec 2017 06:14:57 GMT

Thank you. its work.

Re: Data level section access

devarasu07 — Tue, 26 Dec 2017 06:18:49 GMT

Hi,

Np, close this thread by marking helpful and correct. Thanks

Regards,
Deva

Re: Data level section access

debsahoo — Tue, 26 Dec 2017 06:20:23 GMT

Sorry, my question is same what is I asked initially. But recently I faced a problem to hide data to user whit this script so I asked this.