Data level section access

[debsahoo]

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. 

[Anil_Babu_Samineni]

What is the prblem with Section access?

[debsahoo]

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

[debsahoo]

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

[devarasu07]

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

[debsahoo]

Thank you. its work.

[devarasu07]

Hi,

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

Regards,
Deva

[debsahoo]

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.