topic Re: section access in QlikView

section access

Tue, 17 Jan 2012 20:23:49 GMT

Hi Guys,

Please help me out of this problem:

I have 2 users 1- admin pass : admin

2- user pass : user

I want admin sees every things and users sees just one regional manager from the report.

Thanks,

Re: section access

pover — Tue, 17 Jan 2012 20:34:39 GMT

Columns that link section access with the data model have to be in uppercase letters. The following script worked for me.

Section Access;
LOAD * INLINE [
    ACCESS, USERID, PASSWORD, REGIONAL_MANAGER
    ADMIN, ADMIN, ADMIN, *
    USER, USER, USER, 'SAM, KON'
];
Section Application;
LOAD upper(REGIONAL_MANAGER) as REGIONAL_MANAGER,
     SALES
FROM
[Classeur1.xls]
(biff, embedded labels, table is Feuil1$);

Karl

section access

Tue, 17 Jan 2012 20:54:16 GMT

Thanks karl,

It worked with user name now, you were right.

Could you please give me a hint to change it to NTNAME.

I tried and it did not work.

Thaks,

Nima

Re: section access

pover — Tue, 17 Jan 2012 21:07:12 GMT

Nima,

Replace the USERID and PASSWORD columns with NTNAME. Make sure NTNAME includes the domain and the user. For example, QVDOMAIN\KARLPOVER. You have to be logged on as that user in your computer or accesspoint for this to work.

Karl