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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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.