topic Re: Applying two different section access on two different tables in App Development

Applying two different section access on two different tables

Supriya4 — Sat, 16 Nov 2024 19:38:44 GMT

Hi peeps,

I want to apply two section access tables into two different tables in the load editor. The code is as follows:

Section Access;
Table_1:
LOAD
"ACCESS",
"USERID",
"ACCESS LEVEL"
FROM [lib://Views/section access.xlsx]
(ooxml, embedded labels, table is TEST);

table_2:
LOAD
"ACCESS" as ACCESS1,
"USERID" as USERID1,
"ACCESS LEVEL" as "ACCESS LEVEL1"
FROM [lib://Views/section access_1.xlsx]
(ooxml, embedded labels, table is TEST);

Here in the above code, I tried using two different section access tables, but I don't want to join the section access tables.

The section application code is:

Section Application;

table1:

load

//column names

upper(ACCESS LEVEL) AS ACCESS LEVEL,

FROM [//lib/Views/Live_Data_Test_v2.xlsm]
(ooxml, embedded labels, table is [test]);

table2: //here the table 1 needs to have section access from table_1 and table 2 needs to have SA //from table2

load

//different columns

upper(ACCESS LEVEL1) as "ACCESS LEVEL1",

FROM [//lib/Views/Live_Data_Test.xlsm]
(ooxml, embedded labels, table is [test]);

If I am using this code, the second table(table2) is taking section access from table_1 only, and I am able to see the data from the second table. Can anyone please help me in this? I am new to section access concept in qlik sense.

Re: Applying two different section access on two different tables

NadiaB — Tue, 19 Nov 2019 15:03:52 GMT

Hi @Supriya4

What is the goal you are trying to achieve? Could you provide further details about what is the reason that you would like to have two different tables?

Kind regards.

Re: Applying two different section access on two different tables

Supriya4 — Wed, 20 Nov 2019 06:28:07 GMT

Hi @NadiaB ,

Thanks for the reply!

Ok, let me give you a scenario:

Suppose there are 10 users for the dashboard. all the 10 users are under section access and can view the data correctly according to their access level. But there is table 2, which is NOT JOINED with table1, and I am not able to apply the same section access to that table. I wanted to know how we can achieve applying same section access to the second table, without joining them.

I do not intend to join them, otherwise the purpose of the view shall fail. It would be great if you can help me through!

Thanks Again!

Re: Applying two different section access on two different tables

NadiaB — Wed, 20 Nov 2019 15:31:37 GMT

Hi @Supriya4

Sorry I'm still confused, it is not clear to me the reason behind having two tables, it will be necessary to provide further details to clarify the requirement.

It was mentioned that "the purpose of the view shall fail" if the tables are joined, could you describe what the purpose is? what failure might cause ?

Kind regards.

Re: Applying two different section access on two different tables

Supriya4 — Fri, 22 Nov 2019 11:10:23 GMT

Hi @NadiaB ,

The first table shows data from the file 1. the second table shows the data by comparing anomaly in data that file 1 has, by comparing the data from file 2.

Now suppose if a person A is allowed to see data from file 1 say- ID 1, and person B not allowed to see ID 1. Now, that ID 1 has been identified as an anomaly, so in the second table, it should only be visible to person A, not B .

For this reason I wanted to apply same section access to both the different tables.

I hope I am able to solve your query.

Thanks!

Re: Applying two different section access on two different tables

NadiaB — Mon, 25 Nov 2019 16:08:38 GMT

Hi @Supriya4

I believe I have better understanding of your question but keep in mind the following:

Section access tables are deleted, anything after Section Application won't exist anymore.

In order to have Section Access working the fields need to be named as the valid fields required for section access :ACCESS,USERID,GROUP, other fields will not be recognized.

I would suggest to check @hic post about Section Access to be more familiar with the way that Section Access works.

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Section-Access/ba-p/1465766

Kind Regards.