Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
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.
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.