I am using COUNTRY, REGION and values as ALL in master table.that mean the user should able to see all country and region.
I used STAR IS ALL; but it is not working
Below is my Script:
MASTER:
Load * Inline [
ACCESS, USERID, COUNTRY , REGION , OMIT
USER, qlik\san.mo123, ALL, ALL , PRICE
];
//Star is ALL;
Section Access;
User_access:
LOAD Upper(ACCESS) AS ACCESS,
Upper(USERID) AS USERID ,
Upper(REGION) AS REGION,
Upper(COUNTRY) AS COUNTRY,
Upper(OMIT) AS OMIT
RESIDENT MASTER;
Section Application;
DATA:
Load
Upper(REGION) AS REGION,
Upper(COUNTRY) AS COUNTRY, Upper(OMIT) AS OMIT
Resident MASTER;
Drop Table MASTER;