topic Re: Section access on Hierarchical data set qliksense in App Development

Section access on Hierarchical data set qliksense

Aspiring_Developer — Fri, 26 Jan 2024 14:39:50 GMT

Hi Team ,

I have below data set :-

Employee ID	Employee Name	Designation	Job Level	Salary Data
614	Roy	Senior Manager	C	55
615	Tom	Team Lead	D	45
701	Roger	Business Analyst	E	12
751	Peter	Business Analyst	E	45
888	Adam	Team Lead	D	63

My requirement is we have a filter pane in the front end of 'Job Level'

When a user of job level C comes to see the dashboard , all the data should be visible . Now, when a user of job level D, see report , they should see their data and the data for career level E . Data for C level should not be visible , When a career level E sees, they should only see their data , no data for C, D should be visible . They should not be able to see the data for other E levels as well .

Can anyone please help ? I tried below code ,but is not working :-

Section Access;

// Security Rules
AccessTable:
LOAD * INLINE [
ACCESS, USERID, EMPLOYEE_ID, JOB_LEVEL
ADMIN, ADMIN, *, *
USER, 614, *, C
USER, 615, *, D
USER, 701, *, E
];

Section Application;

// Load your actual data
EmployeeData:
LOAD
EMPLOYEE_ID,
"Employee Name",
Designation,
JOB_LEVEL,
"Salary Data"
INLINE [
614, Roy, 'Senior Manager', C, 55
615, Tom, 'Team Lead', D, 45
701, Roger, 'Business Analyst', E, 12
751, Peter, 'Business Analyst', E, 45
888, Adam, 'Team Lead', D, 63
];

Can anyone please help me with this ? @tresB @sunny_talwar

Re: Section access on Hierarchical data set qliksense

GOKULAKANNAN — Mon, 29 Jan 2024 05:07:25 GMT

Hi ,

Before implementing section access, you should create a hierarchy and then you have to include that hierarchy in section access, for example

ACCESS	USERID	JOB_LEVEL
ADMIN	614	*
USER	615	D
USER	615	E
USER	701	E
USER	888	D
USER	888	E

So once you create this you can further use this to implement section access, to create a hierarchy, just check hierarchy and hierarchy belongs to function in qlik.

Thanks

Re: Section access on Hierarchical data set qliksense

Aspiring_Developer — Mon, 29 Jan 2024 12:10:06 GMT

Hello @GOKULAKANNAN

Thanks for your response. I tried the above approach . However, I don't know how to implement in my hierarchical data set . Could you please help me ?

Re: Section access on Hierarchical data set qliksense

GOKULAKANNAN — Mon, 29 Jan 2024 17:31:22 GMT

Hi @Aspiring_Developer ,

below is the example which i have taken and try to modify based on your need,

EmployeeData:
LOAD
*
INLINE [
EMPLOYEE_ID,EmployeeName,Designation,ParentId,SalaryData
1, Roy, 'Senior Manager', , 55
2, Tom, 'Team Lead', 1, 45
3, Roger, 'Business Analyst', 2, 12
4, Peter, 'Business Analyst', 5, 45
5, Adam, 'Team Lead',1, 63
];

[Ancestry Table temp]:
HierarchyBelongsTo(NodeID, AncestorID, NodeName, AncestorID, AncestorName, DepthDiff)
Load EMPLOYEE_ID as NodeID, ParentId as AncestorID, EmployeeName as NodeName Resident EmployeeData ;

[Ancestry Table]:
Load
NodeID,
NodeName,
AncestorID,
AncestorName as [Rollup Emp],
DepthDiff
Resident [Ancestry Table temp];
// drop temp table.
drop table [Ancestry Table temp];

Refer the page : Hierarchies in Qlik Sense - BigBear.ai

Thanks

Re: Section access on Hierarchical data set qliksense

hic — Mon, 29 Jan 2024 19:55:00 GMT

Re: Section access on Hierarchical data set qliksense

Aspiring_Developer — Tue, 30 Jan 2024 15:37:58 GMT

Hi @GOKULAKANNAN @hic

Thanks for your response. I've gone through the links and code snippets and this is what my code looks like :-

Data Model Viewer

We are not linking the two tables as it fact table measures should not be impacted by the filters of Ancestory table

I am very new to this hierarchical concept and not sure what to do next .Can anyone please help me on this ?

Thanks

Re: Section access on Hierarchical data set qliksense

GOKULAKANNAN — Tue, 30 Jan 2024 15:59:28 GMT

Hi @Aspiring_Developer ,

from the above script, you will get Nodename and rollup emp, rollup emp should be NTNAME and Nodename should be renamed as NODENAME.

So while writing section access,

Section access;

Load

'USER' as ACCESS,

NTNAME ,

NODENAME

resident TableName;

So with the above table add the admin users as well, this will create a section access with hierarchy.

Re: Section access on Hierarchical data set qliksense

Aspiring_Developer — Tue, 30 Jan 2024 17:10:03 GMT

Hi @GOKULAKANNAN

Thank you for your response .

I tried below script and even added my ID and name in it in order to see the application myself in the section access :-

After reload , it is giving me below :-

Not sure , what I did wrong ?

Re: Section access on Hierarchical data set qliksense

GOKULAKANNAN — Tue, 30 Jan 2024 16:37:13 GMT

Hi @Aspiring_Developer ,

If you have a domain name then you have to add it, to find the domain name, inside the sheet create a KPI and add OSuser() as a measure , you will get 2 things, first one is domain , second one will be your user id, so for example , RE is domain, and GK is id, u have to mention it like "RE\GK" as NTNAME. Then only it will work, else it wont.

Re: Section access on Hierarchical data set qliksense

Aspiring_Developer — Tue, 30 Jan 2024 17:11:26 GMT

Hi @GOKULAKANNAN

Please see below :-

I think I am making some mistake here in the section access script :-

Am not sure about the section access script . Do I need to define the rules here , not sure 😞

Re: Section access on Hierarchical data set qliksense

GOKULAKANNAN — Tue, 30 Jan 2024 17:02:51 GMT

Hi @Aspiring_Developer ,

Write this and execute

Section access;

Load * inline

[

ACCESS,NTNAME,NODENAME

'ADMIN', ur user id with domain, *

];

Thus u include it after the section access; key word,and keep the existing code as it is

Re: Section access on Hierarchical data set qliksense

Aspiring_Developer — Tue, 30 Jan 2024 17:15:17 GMT

Hi @GOKULAKANNAN

Thank you very much for your help .

My last question to you is If I talk about the rest of the users, Do, I need to add their details in the preceding load of section access . I have not yet tested it with other users . How their access rule will be replicated when they will log in. If I need to section access preceding load inline table , How will I define for the rest of the Employee _Id's ?

Re: Section access on Hierarchical data set qliksense

GOKULAKANNAN — Tue, 30 Jan 2024 17:20:27 GMT

Hi @Aspiring_Developer , If u want to create for other users, u have to mention the ID properly with the domain name, and give parent id properly and use hierarchy function and it will create a hierarchy, validate it once before you implement the section access.

NTNAME should be the parent name, NODENAME should be the child.

So if Roy is the manager he should be tagged with all his child values, so for roy 5 rows should be there (considering 4 employees)

In this way it will work, and u dont need to do anything else just to provide you the admin access we have added the inline in section access , that u have to keep, dont remove it

Re: Section access on Hierarchical data set qliksense

Aspiring_Developer — Tue, 30 Jan 2024 18:14:21 GMT

Thanks a lot @GOKULAKANNAN for your help.

As you said I need to mention the ID properly with the domain name, and give parent id properly and use hierarchy function and it will create a hierarchy, validate it once before you implement the section access.

Where should I define these user id's and domain name . Could you please explain it with my data set . A small table ?

This is my current script :-

Data:
Load * Inline [
Employee_ID, Employee_Name, Designation, Job_Level, Salary_Data
614, Roy, Senior Manager, C,55
615, Tom, Team Lead , D, 45
701, Roger, Business Analyst , E, 12
751, Peter, Business Analsyt, E, 45
888, Adam, Team Lead , D, 63
614142523,Vaishali, CEO,*, 79

];

Ancestory_Table_Temp:
HierarchyBelongsTo(NodeID,AncestorID,NodeName, AncestorID,AncestorName,DeptDiff)
Load Employee_ID as NodeID, Job_Level as AncestorID,Employee_Name as NodeName
Resident Data;

Ancestory_Table:
Load NodeID,
NodeName,
AncestorID,
AncestorName as [Rollup Emp],
DeptDiff
Resident Ancestory_Table_Temp;

drop table Ancestory_Table_Temp;

// Implementing Section Access---//

Section Access;

Load * inline

[

ACCESS,NTNAME,NODENAME

'ADMIN', IUSER\61414234, *,

];

Load

'USER' as ACCESS,

[Rollup Emp] as NTNAME ,

NodeName as NODENAME

resident Ancestory_Table;

Section Application;

What I need to do in the above script ?