Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Clever_Anjos
Employee
Employee

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
Author

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

Not applicable
Author

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
Author

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
Partner Ambassador
Partner Ambassador

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

];

Clever_Anjos
Employee
Employee

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

];