QlikView Section Access, <ANY> works for ADMIN, fails for USER

[#1]

Hi all,

I have a model, with a list of countries {USA, UK, GERMANY}.

I have made restrictions for access on reduced data (countries) and Sheets.

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, PROFILE, COUNTRY

    ADMIN, ADMIN, 999, FULL, <ANY>

    USER, USER1, 111, VIEWER-HIGH, UK

    USER, USER2, 222, VIEWER-LOW, <ANY>

];

Section Application;

LOAD * INLINE [

PROFILE, SHDASHBOARD, SHSALES, SHWHATIF, SHTIME, SHBASKET, SHCOMPARE, SHREPORT

FULL, 1, 1, 1, 1, 1, 1, 1

VIEWER-HIGH, 1, 0, 1, 0, 1, 0, 0

VIEWER-LOW, 1, 0, 0, 0, 0, 0, 1

];

All is working fine on ADMIN and USER1, however, USER2 cannot access the application.
If I switch the COUNTRY for USER2 to a country, it works fine.
Is there a reason <ANY> wont work for users? Did anyone encounter this before?

Thanks

[#2]

Ok, mixed up the ANY and ALL strings.
Thank you all, it is working great

[Peter_Cammaert]

If the COUNTRY values are not all in Uppercase in the Customers table, no need to convert them. Only the values that connect to Section Access need to be in upper case (e.g. the values in field _PERMISSION). Use something like this instead:

_Permissions:

LOAD DISTINCT

     Upper(Country) AS _PERMISSION,

     Country // Links to Customers table

RESIDENT Customers;

CONCATENATE (_Permissions)

LOAD DISTINCT

     '<ANY>' AS _PERMISSION,

     Country

RESIDENT Customers;