Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Data Reduction AND OR Operations on Multiple Dimensions

Hi there,

I am trying to use data reduction to filter the data corresponding to individual users and my dimensions are not hierarchial. I am able to achieve data reduction on AND  & OR operations in isolation.  However, if my users list in the Section Access some are AND operation and some are OR operation, the data reduction seems not quite work and I need some help on that.

My section access are as follows:

OR operation

    ACCESS, NTNAME, OP, FILTER, COSTFILTER, CATFILTER

    ADMIN, ERIC.LAM, OR, PET MANAGEMENT, *, *

    ADMIN, ERIC.LAM, OR, DIRECT, *, *

AND operation

    ACCESS, NTNAME, OP, FILTER, COSTFILTER, CATFILTER

    ADMIN, MAT.LAM, AND, , PET MANAGEMENT, DIRECT

Mixture of AND & OR

    ACCESS, NTNAME, OP, FILTER, COSTFILTER, CATFILTER

    ADMIN, ERIC.LAM, OR, PET MANAGEMENT, *, *

    ADMIN, ERIC.LAM, OR, DIRECT, *, *

    ADMIN, MAT.LAM, AND, , PET MANAGEMENT, DIRECT

Many thanks in advance,

Eric.

0 Replies