Hi All,
Please help me with section access in qliksense.
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;
Table
T1
COUNTRY | SALES |
IND | 500 |
UK | 200 |
US | 300 |
IND | 123 |
T2
REGION | PRICE | COUNTRY |
E | 100 | IND |
W | 200 | UK |
C | 350 | US |
E | 605 | IND |
Output i am getting :