Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
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