Qlik Community

QlikView Security & Governance

Discussion Board for collaboration on QlikView Security and Governance.

Not applicable

Reduction fields is not working

This is the code written in hidden script. Department is a column in my data model.When I am logging with user credentials the filters are not working.Strict Exclusion properties are already checked. Need help. Thanks in advance.

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, Department1

    admin, 1, 1, *

    user, user2, 2, Computer

    user, user3, 3, Electrical

    user, user4, 4, Chemical

];

Section Application;

LOAD * INLINE [

    Department, Department1

    CSE, Computer

    EEE, Electrical

    CHE, Chemical

];

6 Replies
Employee
Employee

Re: Reduction fields is not working

Department1 must be UPPERCASE


Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, DEPARTMENT1

    admin, 1, 1, *

    user, user2, 2, Computer

    user, user3, 3, Electrical

    user, user4, 4, Chemical

];

Section Application;

LOAD * INLINE [

    Department, DEPARTMENT1

    CSE, Computer

    EEE, Electrical

    CHE, Chemical

];

Not applicable

Re: Reduction fields is not working

after doing this no user is able to open the document except the admin user.

Not applicable

Re: Reduction fields is not working

above code is not working...User cant even open the document...with lower case department1 atleast user was able to open the document

Not applicable

Re: Reduction fields is not working

It works fine.


Change it to :

LOAD * INLINE [



    ACCESS, USERID, PASSWORD, DEPARTMENT



    admin, 1, 1, *



    user, user2, 2, CSE



    user, user3, 3, EEE



    user, user4, 4, CHE



]
;



Section Application;







LOAD * INLINE [



    DEPARTMENT, Department1



    CSE, Computer



    EEE, Electrical



    CHE, Chemical



]
;

michael_maeuser
Contributor III

Re: Reduction fields is not working

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, DEPARTMENT1

    admin, 1, 1, *

    user, user2, 2, COMPUTER

    user, user3, 3, ELECTRICAL

    user, user4, 4, CHEMICAL

];

Section Application;

LOAD * INLINE [

    Department, DEPARTMENT1

    CSE, COMPUTER

    EEE, ELECTRICAL

    CHE, CHEMICAL

];

Employee
Employee

Re: Reduction fields is not working

Sorry, field values has to be uppercase too

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, DEPARTMENT1

    admin, 1, 1, *

    user, user2, 2, COMPUTER

    user, user3, 3, ELECTRICAL

    user, user4, 4, CHEMICAL

];

Section Application;

LOAD * INLINE [

    Department, DEPARTMENT1

    CSE, COMPUTER

    EEE, ELECTRICAL

    CHE, CHEMICAL

];

Community Browser