Qliksense Section Access

Santosh — Sat, 16 Nov 2024 21:40:19 GMT

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

COUNTRY	SALES
IND	500
UK	200
US	300
IND	123

REGION	PRICE	COUNTRY
E	100	IND
W	200	UK
C	350	US
E	605	IND

Output i am getting :

topic Qliksense Section Access in QlikView

Qliksense Section Access