Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
MuraliPrasath
Creator III
Creator III

SectionAccess Help.

Hi, I've attached the Excel Doc contains two sheets. I need NT Login Script.

Pls someone give me a scrip to apply section access.

I've tried the following but after save and close Document is fail to open says. Access Denied to this QV Doc.

SECTION Access;

Access:

LOAD ACCESS,

     upper(NTNAME) as NTNAME,

     upper(SALESREP) as SALESREP

FROM

(ooxml, embedded labels, table is section)

Where 1=1;

SECTION Application;

SalesRep:

LOAD  upper(SALESREP) as SALESREP,

     SALESREP as SalesRep

FROM

(ooxml, embedded labels, table is section) Where 1=1;

asdf:

LOAD SalesRep,

     Sales

FROM

(ooxml, embedded labels, table is Project);

4 Replies
PrashantSangle

Hi,

What is your desktop login Name

check it by using osuser()

and add that name in your excel file.

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
qlikviewwizard
Master II
Master II

Hi,Please check this thread.

Section Access

MuraliPrasath
Creator III
Creator III
Author

TXT\msrithar   is my desktop login

PrashantSangle

Hi,

add TXT\msrithar  in your xls file under NTNAME column

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂