topic Re: Section Access Query. in QlikView

Section Access Query.

MuraliPrasath — Tue, 06 Oct 2015 06:38:44 GMT

Hi QV Team,

I've to appy Section Access on my Application based on NT Login.

I've created a hidden script and used following script.

************************************

Section Access;

LOAD * INLINE [

ACCESS, NTNAME

USER, TXT/AAndrade

USER, TIC/AParonica

USER, TXT/gbagby

ADMIN, TXT/sbaggiano

ADMIN, TXT/jbarrett

];

Section Application;

LOAD ACCESS,

NTNAME,

EmailID,

Sales_Representative

FROM

[..\..\Data\FlatFiles\ABC_SectionAccess_userextract.xls]

(biff, embedded labels, table is ABC_SectionAccess_userextra$);

***************************************

After doing this, i can't able to open the document anymore.

It says "Access denied".

My requirement is to reduce the fields based on the user login(NT Login)

Please some one suggest me some thing.

Re: Section Access Query.

PrashantSangle — Tue, 06 Oct 2015 06:43:14 GMT

Hi,

try NTNAME list in capital latter.

Regards

Re: Section Access Query.

qlikviewwizard — Tue, 06 Oct 2015 06:47:44 GMT

Hi murali69

Section works on case sensitive and should use capital letters.

Re: Section Access Query.

jonathandienst — Tue, 06 Oct 2015 06:57:53 GMT

Section Access;

LOAD ACCESS,

Upper(NTNAME) As NTNAME

INLINE [

ACCESS, NTNAME

USER, TXT/AAndrade

USER, TIC/AParonica

USER, TXT/gbagby

ADMIN, TXT/sbaggiano

ADMIN, TXT/jbarrett

];

Re: Section Access Query.

sujeetsingh — Tue, 06 Oct 2015 06:59:50 GMT

Follow the thread

Section Access using NTName Issue

Re: Section Access Query.

MuraliPrasath — Tue, 06 Oct 2015 09:26:37 GMT

Hi,

I followed this method but still I'm facing the same issue. After following this I'm unable to open the document.

" Access Denied to this document".

Re: Section Access Query.

nagarjuna_kotha — Tue, 06 Oct 2015 09:29:46 GMT

Check this :

Section Access using NTName Issue

Re: Section Access Query.

PrashantSangle — Tue, 06 Oct 2015 09:43:45 GMT

Hi,

You are login with which userName???

Regards

Re: Section Access Query.

qlikviewwizard — Tue, 06 Oct 2015 09:49:03 GMT

Did your NT USERNAME details added into the script?

We should add.

Are you opening this in personal edition?

If yes,

Did you lease the license from the server?

Re: Section Access Query.

Tue, 06 Oct 2015 09:51:36 GMT

One trick that might help you to find a solution could be to create a text-box and add =osuser() to make sure the username that QV fetches looks the same as the ones in your list.

Re: Section Access Query.

Tue, 06 Oct 2015 09:52:46 GMT

A very good post by Henric A Primer on Section Access

Re: Section Access Query.

avinashelite — Tue, 06 Oct 2015 09:56:46 GMT

have you added your self in the NTNAME list ?? because it will not prompt for username it will directly read from the network !!