Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Section access based on Section Application

Hello,

How come this does not work?

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD

    ADMIN, ADMIN, ADMIN

    USER, Hans, DuEr1

    USER, Kent, DuEr2

    USER, Olga, DuEr3

];

Section Application;

LOAD * Inline [

USERID, CustomerID

Hans, UHMD

];

I want the user hans only able to see CustomerID UHMD (its a string)

I have this table in my edit script

QUALIFY*;

UNQUALIFY CustomerKey;

DimCustomer:

LOAD CustomerKey,

    PartnerID,

    CustomerID,

    PartnerKey,

    LaCustomerKey;

SQL SELECT *

FROM DW.dbo.DimCustomer;

UNQUALIFY*;

When i try to go into my qvw doucment i get access denied, except on admin level, i am allowed to go to my qvw file.

Tags (2)
3 Replies
Not applicable

Re: Section access based on Section Application

okay What do i do if i closed my self out of the document ? i just tried with NTname, and now i cannot access my document.

msheraton
Contributor III

Re: Section access based on Section Application

Did you back it up?

It's good to backup any seciton access document before you make changes (I guess you know why...)

Not applicable

Re: Section access based on Section Application

hehe no i forgot but yes, i was very stupid ;D

Community Browser