Filter the data based on who logged in , Department wise

[Saif1]

Hi all,

So the scenario is this , we have multiple employees with there respective departments with them , EX :

John , HR

SAIF , Finance

Lets say that John has logged in into a streamed public app that all departments can see, 

now how can I filter all the charts to have john only see HR data ?

lets say that we have a table with employee names like this 

Name,Department,Salary

John , HR , 500

SAIF , Finance , 500

How can i let john not to see SAIF's Row because john is HR not Finance ? 

bottom line is that i want to do section access on row level based but from category.

How can i do this ??

[luizcdepaula]

Hi Saif,

You accomplish that in the script level applying the initial statements "Section Access" and "Section Application". Find an example I created below:

Section Access;
Load * INLINE [
ACCESS, UserId, REDUCTION
USER, AD_DOMAIN\John, HR
USER, AD_DOMAIN\SAIF, FI
];

Section Application;
Acumulado:
Load * Inline [
DATE LOCATION CC ACCOUNT VALUE REDUCTION
01/01/2022 101 001 123 22 HR
01/01/2022 101 001 142 78 HR
01/01/2022 101 002 123 542 HR
01/01/2022 101 002 254 21 HR
01/02/2022 101 002 254 658 FI
01/02/2022 102 000 123 0 FI
01/02/2022 102 001 254 78 FI
01/02/2022 102 002 123 298 FI
01/02/2022 102 002 142 55 FI
](delimiter is ' ')

The link below has more information.

https://help.qlik.com/en-US/sense/May2022/Subsystems/Hub/Content/Sense_Hub/Scripting/Security/manage... 

I hope it helps.

Cheers,

Luiz

[BrunPierre]

This will get you started section access data reduction

[Saif1]

Hi Luiz , thank you so much for the reply ,

I know it is related to section access , but mainly section access is omitting the whole field,

what i want is to make a universal table that has 4 departments (finance ,HR ,Training ,Procurement)

and that table has employee names and there departments , and based on what is the role a user log in with ( in the QMC to be labeled as one of the 4 department, i want to omit the *ROWS* that don't have the person who logged in department , let us say if a person from HR logged in , all other than HR is omitted , not a (field/Column).

[BrunPierre · Accepted solution]

@Saif1 It is answered on this thread row level security, how to?