Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save an extra $150 Dec 1–7 with code CYBERWEEK - stackable with early bird savings: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
NavinReddy
Creator II
Creator II

Section Access

Hi All,

I am trying to implimenting section Access

im Login with ADMIN access i can see every thing

If i login with USER access i can see only UK data and so on

but this code not working for me

   Section Access;  

    LOAD * INLINE [

        ACCESS, USERID, PASSWORD, Country

        ADMIN , ADMIN, ADMIN,*

        USER, UK, UK, UK

        USER, North America, North America, North America

        USER, Germany, Germany, Germany

        USER,Nordics,Nordics

      

    ];

    Section Application;

    Star is *;

    LOAD * INLINE [

    Country,Team Name1

    UK,UK - South

    North America ,NA-North

    Germany,Germany - West

    Nordics,Nordics - North

    ];

  

Thanks In Advance

Niranjan

1 Solution

Accepted Solutions
fernando_tonial
Employee
Employee

Hi Niru,

Again my example attach.

User ADMIN, i can add sheet objects.

19-02-2014 15-21-14.png

User UK, i can´t add sheet objects. and not edit script, not reload...

19-02-2014 15-22-05.png

You need change the document properties and sheet properties, in both sheet Security.

Best Regards.

Tonial.

Don't Worry, be Qlik.

View solution in original post

14 Replies
Nicole-Smith

Settings > Document Properties > Opening

Make sure you check "Initial Data Reduction Based on Section Access" and "Strict Exclusion"

luis_pimentel
Partner - Creator III
Partner - Creator III

Like previous said:

Settings > Document Properties > Opening

Make sure you check "Initial Data Reduction Based on Section Access" and "Strict Exclusion"

Cheers.

Luis.

NavinReddy
Creator II
Creator II
Author

yes i did that

you can find the attachment

fernando_tonial
Employee
Employee

Hi, all fields of the section access must be upper case.

Change "Country" for "COUNTRY". See this example the script:

Section Access; 

    LOAD * INLINE [

        ACCESS, USERID, PASSWORD, COUNTRY

        ADMIN , ADMIN, ADMIN,

        USER, UK, UK, UK

        USER, North America, North America, North America

        USER, Germany, Germany, Germany

        USER,Nordics,Nordics

     

    ];

    Section Application;

    Star is *;

    LOAD * INLINE [

    COUNTRY,Country

    UK, UK

    North America, North America

    Germany, Germany

    Nordics, Nordics

    ];

or

See my app.

Best Regards.

Tonial.

Don't Worry, be Qlik.
NavinReddy
Creator II
Creator II
Author

guys any idea.......

fernando_tonial
Employee
Employee

See my previous post.

Don't Worry, be Qlik.
NavinReddy
Creator II
Creator II
Author

HI,

if login with user credentials

im getting admin rights

Best regards,

Niranjan

fernando_tonial
Employee
Employee

you need change this options in your document.

19-02-2014 14-30-50.png

Best Regards.

Tonial.

Don't Worry, be Qlik.
NavinReddy
Creator II
Creator II
Author

Hi Tonial,

I am sorry its not working for me

plz check........

Best regards,

Niranjan