topic Re: Data reduction with qualified field name in QlikView

Data reduction with qualified field name

Tue, 19 May 2015 03:54:55 GMT

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;

Re: Data reduction with qualified field name

swuehl — Tue, 19 May 2015 15:50:26 GMT

Have you tried with a UPPER case table name?

Re: Data reduction with qualified field name

Wed, 20 May 2015 01:03:23 GMT

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.

Re: Data reduction with qualified field name

Anonymous — Wed, 20 May 2015 02:19:44 GMT

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.