Section Access with two fields

Fri, 23 Dec 2011 10:36:30 GMT

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.

Section Access with two fields

Anonymous — Fri, 23 Dec 2011 18:49:12 GMT

Its application is blocked.

topic Section Access with two fields in QlikView

Section Access with two fields

Section Access with two fields