Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Santosh
New Contributor III

Qliksense Section Access

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

COUNTRYSALES
IND500
UK200
US300
IND123

 

T2

REGIONPRICECOUNTRY
E100IND
W200UK
C350US
E605IND

 

Output i am getting :

 access.JPG