Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Data reduction with qualified field name

I am trying to restrict a user to see the data from only one company, CIC, using data reduction.  All of our columns are qualified.  However, when I try the code below, it doesn't work.  I have set "Initial Data Reduction Based on Section Access" and "Strict Exclusion".  I also can't seem to find an example of a Section Access using qualified field names.

Can anyone please help?  Thanks.

Section Access;

LOAD * INLINE [

    ACCESS, USERID, ProductPlan.COMPANY

    admin, qlikadmin, *

    user, user01, CIC

];

Section Application;

1 Solution

Accepted Solutions
Champion III
Champion III

I'd rather avoid using qualified field name for data reduction, but there was another problem with your original section access.  Filed name used for data reduction must have name in ALL CAPS, not just the data.  You've obviously fixed this problem by using field name DATA_REDUCTION_COMPANY.

View solution in original post

3 Replies
MVP
MVP

Have you tried with a UPPER case table name?

Not applicable

Yes, I have tried using upper case table names but it didn't work either.  In the end, I just created an unqualified column DATA_REDUCTION_COMPANY and used that instead for data reduction.

Champion III
Champion III

I'd rather avoid using qualified field name for data reduction, but there was another problem with your original section access.  Filed name used for data reduction must have name in ALL CAPS, not just the data.  You've obviously fixed this problem by using field name DATA_REDUCTION_COMPANY.

View solution in original post