topic Re: Section Access for Multiple Tables in App Development

Section Access for Multiple Tables

acrodrigues03 — Tue, 20 Aug 2019 16:21:57 GMT

Hi everyone,

I have multiple tables that I need to filtered based on the country from the section access. All of the tables contain a Country field, but I would like to hide them at the end.

I have the following script right now:

Section Access;
LOAD
"ACCESS",
"USERID",
UPPER("COUNTRY CODE") AS "COUNTRY"
FROM [lib://...\SECTION_ACCESS.qvd]
(qvd);

Section Application;

TABLE1:
LOAD
"Table 1 ID",
"COUNTRY"
FROM [lib://.../M_TABLE1.qvd](qvd);

TABLE2:
LOAD
"Table 2 ID",
"COUNTRY 2"
FROM [lib://.../M_TABLE2.qvd](qvd)

where exists ("COUNTRY","COUNTRY 2");

The issue is that this works for TABLE1 since they have the same field name but then the "where exists" is not working in the other table to get only the ones that users are allowed to see.

I could rename every country field in every table so it would match with the one in the section access, but then I would be doing unwanted connections. And also, if possible, I would like to not have the Country fields in the data model.

Thank you

Re: Section Access for Multiple Tables

Sebastiaandb — Wed, 21 Aug 2019 06:35:07 GMT

Can't you just make another table combining the other tables without the country field and then drop the other tables? 🙂

Re: Section Access for Multiple Tables

acrodrigues03 — Wed, 21 Aug 2019 08:30:16 GMT

Hey Sebastian,

Unfortunately, I can't, cause I have a country field in every table of the data model. And every table should be restricted, so I can't just do a combining table

Re: Section Access for Multiple Tables

Or — Wed, 21 Aug 2019 08:48:29 GMT

You could use OMIT Country* in your section access, I think. If memory serves, Omit accepts wildcards.

Re: Section Access for Multiple Tables

acrodrigues03 — Wed, 21 Aug 2019 12:51:15 GMT

Thank you! That helps to hide the country fields, but than I still don't know how can I restrict every country field from every table.

I thought about doing something like:

Section Access;
LOAD
"ACCESS",
"USERID",
UPPER("COUNTRY CODE") as "COUNTRY",
UPPER("COUNTRY CODE") as "COUNTRY 2",

...
FROM [lib://...\SECTION_ACCESS.qvd]
(qvd);

But when I add more than 1 field to restrict, I loose access to the application.

Re: Section Access for Multiple Tables

Or — Thu, 22 Aug 2019 08:29:21 GMT

I have no idea if this can be achieved without some sort of bridge table. Not something I've ever tried to do..

Have a look at this, it may help:

https://community.qlik.com/t5/Qlik-Sense-App-Development/Section-Access-On-Multiple-Tables-with-different-dataset-using/m-p/108783