Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
debsahoo
Contributor III
Contributor III

Data level section access

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. 

9 Replies
Anil_Babu_Samineni

What is the prblem with Section access?

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
debsahoo
Contributor III
Contributor III
Author

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 .

Anil_Babu_Samineni

May be QlikView Section Access Examples

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
debsahoo
Contributor III
Contributor III
Author

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;

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

Anil_Babu_Samineni

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..

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
devarasu07
Master II
Master II

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)

2.JPG

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)

222.JPG

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

debsahoo
Contributor III
Contributor III
Author

Thank you. its work.

devarasu07
Master II
Master II

Hi,

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

Regards,
Deva

debsahoo
Contributor III
Contributor III
Author

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.