Section Access on Two Fields in QlikSense

[nishika]

I need to apply section access on two field TERRITORY_1 AND SUBTERRITORY_1

Below script is working for ADMIN only and for Users it is giving Access Denied. Please help.

Temp_SA:
LOAD
"ACCESS",
"USERID",
TERRITORY_1,
SUBTERRITORY_1
FROM [lib://xyz/Section_Access.xlsx]
(ooxml, embedded labels, table is Sheet1);

Concatenate(Temp_SA)
LOAD
'ADMIN' AS ACCESS,
'DUMMY' AS USERID,
TERRITORY_1,
SUBTERRITORY_1

RESIDENT KEY;

SECTION ACCESS;

STAR IS *;

SA:
LOAD Distinct
ACCESS,
USERID,
//TERRITORY_1,
//SUBTERRITORY_1,
TRIM(UPPER(TERRITORY_1))&TRIM(UPPER(SUBTERRITORY_1)) AS TEST
Resident Temp_SA;

SECTION APPLICATION;

DROP TABLE Temp_SA;

EXIT Script;

[GovindGSC]

Hello,

Were you able to find a solution for this? Please let me know if you did.

Thank you.

[nishika]

Hi,

Please find attached excel file.

And also find below script.

Section Access;

LOAD

"ACCESS",

"USERID",

TRIM(UPPER(TERRITORY_1)) AS TERRITORY_1,

TRIM(UPPER(SUBTERRITORY_1)) AS SUBTERRITORY_1

FROM [lib://path/Section Access.xlsx]
(ooxml, embedded labels, table is Sheet1);

Section Application;

[agigliotti]

Hi @nishika ,

I can't see your data tables in section application, so i can't help you.
The "Access Denied" message could also means that you don't have any data matching with reduction fields values.

[AshutoshBhumkar]

Hi,

As the data is not available, it would be difficult to give solution.

But you can check below things to ensure Section Access working.

• Upper fields in both the set (Section Access and Data).
• Data availability in the Dataset.
• Use generic keys if access is based on multiple fields.

Thanks,

Ashutosh