topic Re: Section Access in QlikView

Section Access

NavinReddy — Wed, 19 Feb 2014 16:28:16 GMT

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

Re: Section Access

Nicole-Smith — Wed, 19 Feb 2014 16:34:11 GMT

Settings > Document Properties > Opening

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

Re: Section Access

luis_pimentel — Wed, 19 Feb 2014 16:43:10 GMT

Like previous said:

Settings > Document Properties > Opening

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

Cheers.

Luis.

Re: Section Access

NavinReddy — Wed, 19 Feb 2014 16:48:31 GMT

yes i did that

you can find the attachment

Re: Section Access

fernando_tonial — Wed, 19 Feb 2014 17:10:32 GMT

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

];

See my app.

Best Regards.

Tonial.

Re: Section Access

NavinReddy — Wed, 19 Feb 2014 17:10:55 GMT

guys any idea.......

Re: Section Access

fernando_tonial — Wed, 19 Feb 2014 17:19:30 GMT

See my previous post.

Re: Section Access

NavinReddy — Wed, 19 Feb 2014 17:28:51 GMT

HI,

if login with user credentials

im getting admin rights

Best regards,

Niranjan

Re: Section Access

fernando_tonial — Wed, 19 Feb 2014 17:34:03 GMT

you need change this options in your document.

Best Regards.

Tonial.

Re: Section Access

NavinReddy — Wed, 19 Feb 2014 18:12:33 GMT

Hi Tonial,

I am sorry its not working for me

plz check........

Best regards,

Niranjan

Re: Re: Section Access

fernando_tonial — Wed, 19 Feb 2014 18:27:54 GMT

Hi Niru,

Again my example attach.

User ADMIN, i can add sheet objects.

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

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

Best Regards.

Tonial.

Re: Section Access

Wed, 19 Feb 2014 18:29:48 GMT

Hi Niru,

Try to change the * character to - character for the ADMIN user.

Best Regards.

Re: Section Access

Wed, 19 Feb 2014 18:34:28 GMT

And another thing... I have a project implementation with section access, in this I used the - character and in Document Options -> Opening I have unckecked "Strict Exclusion". You can try with this alternative.

Re: Section Access

Anonymous — Wed, 19 Feb 2014 20:38:51 GMT

Hi Niru,

Remove Star is * and try once

Re: Section Access

NavinReddy — Thu, 20 Feb 2014 04:31:26 GMT

Thanks you so much Tonial

Best Regards,

Niranjan