Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Santosh
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

 

0 Replies