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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
MuraliPrasath
Creator III
Creator III

Section Access Query.

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.

11 Replies
Not applicable

A very good post by Henric A Primer on Section Access

avinashelite

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