Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

NavinReddy
Contributor 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
Valued Contributor

Re: Re: Section Access

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.

14 Replies

Re: Section Access

Settings > Document Properties > Opening

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

luis_pimentel
Contributor III

Re: Section Access

Like previous said:

Settings > Document Properties > Opening

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

Cheers.

Luis.

NavinReddy
Contributor II

Re: Section Access

yes i did that

you can find the attachment

fernando_tonial
Valued Contributor

Re: Section Access

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.

NavinReddy
Contributor II

Re: Section Access

guys any idea.......

fernando_tonial
Valued Contributor

Re: Section Access

See my previous post.

NavinReddy
Contributor II

Re: Section Access

HI,

if login with user credentials

im getting admin rights

Best regards,

Niranjan

fernando_tonial
Valued Contributor

Re: Section Access

you need change this options in your document.

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

Best Regards.

Tonial.

NavinReddy
Contributor II

Re: Section Access

Hi Tonial,

I am sorry its not working for me

plz check........

Best regards,

Niranjan

Community Browser