topic Re: Reduction fields is not working in QlikView

Reduction fields is not working

Mon, 26 Jan 2026 18:19:17 GMT

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

];

Re: Reduction fields is not working

Clever_Anjos — Thu, 12 Dec 2013 13:31:34 GMT

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

];

Re: Reduction fields is not working

Thu, 12 Dec 2013 13:49:02 GMT

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

Re: Reduction fields is not working

Thu, 12 Dec 2013 13:57:23 GMT

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

Re: Reduction fields is not working

Thu, 12 Dec 2013 14:08:35 GMT

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

];

Re: Reduction fields is not working

michael_maeuser — Thu, 12 Dec 2013 14:09:11 GMT

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

];

Re: Reduction fields is not working

Clever_Anjos — Thu, 12 Dec 2013 15:53:20 GMT

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

];