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

Section Access with two fields

I'm trying to use section access to combine two fields (COUNTRY, PRODUCT) with the script below. However I have unwanted results:

I want that USER A is able to see all products from FRANCE and all the countries where the BALL or BASKET has been sold. However, what I get is only products BALL or BASKET sold to FRANCE.

I want that USER G is able to see all products sold to GERMANY and all countries where BALL has been sold. However, what I get is access denied.

How can I combine fields? What are the limitations?

Section Access;
USERS:
LOAD * INLINE [
    ACCESS, USERID, PASSWORD, COUNTRY, PRODUCT
    ADMIN, ADMIN, ADMIN
    USER, A, A, FRANCE
    USER, A, A, , BALL
    USER, A, A, , BASKET
    USER, B, B, FRANCE, BALL
    USER, C, C, GERMANY
    USER, D, D, UK,
    USER, F, F, , BASKET
    USER, G, G, GERMANY
    USER, G, G, , BALL
];
Section Application;

SALES:
LOAD * INLINE [
    COUNTRY, PRODUCT, SALES
    SPAIN, BALL, 100
    UK, BALL, 500
    FRANCE, BASKET, 150
    GERMANY, SHOES, 200
    FRANCE, BALL, 100
    SPAIN, SHOES, 100
    UK, SHOES, 50
    SPAING, BASKET, 60

    FRANCE, SHOES, 100
];

I have added the test document.

1 Reply
Anonymous
Not applicable
Author

Its application is blocked.