topic Re: SectionAccess Help. in QlikView

SectionAccess Help.

MuraliPrasath — Wed, 07 Oct 2015 05:39:17 GMT

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);

PrashantSangle — Wed, 07 Oct 2015 05:49:33 GMT

Hi,

What is your desktop login Name

check it by using osuser()

and add that name in your excel file.

Regards

qlikviewwizard — Wed, 07 Oct 2015 05:54:00 GMT

Hi,Please check this thread.

MuraliPrasath — Wed, 07 Oct 2015 05:57:23 GMT

TXT\msrithar is my desktop login

PrashantSangle — Wed, 07 Oct 2015 06:01:51 GMT

Hi,

add TXT\msrithar in your xls file under NTNAME column

Regards