Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
ibaydinatmn
New Contributor

multiple section access tables, all with USERID field

Can I have two section access tables (both with USERID field) in order to reduce the data through two dimension tables, as follows?

Section Access:

Table1:

USERIDPRODUCT_ID
USER1A
USER2B

Table2:

USERIDCOUNTRY_ID
USER110
USER220

Section Application:

ProductDim:

PRODUCT_IDPRD_NAME
APhone
BTelevision

CountryDim:

USERIDCOUNTRY_ID
10USA
20Canada

FactTable

PRODUCT_IDCOUNTRY_IDSales
A10100
B20200

So that, fact table data is reduced to records where PRODUCT_ID=A and COUNTRY_ID=10 for USER1.

Thx


PRODUCT_IDPRODUCT_ID

2 Replies
sinanozdemir
Valued Contributor III

Re: multiple section access tables, all with USERID field

Hi,

How about something like the below:

Capture.PNG

You join Table1 and Table2 in order to create the users and their restrictions.

I am also attaching the app.

Let me know if this works for you.

Thanks

ibaydinatmn
New Contributor

Re: multiple section access tables, all with USERID field

This will work, however I would like to avoid joining two tables, as in my case, it will create a very large table.

That is why I wonder if it is possible to use two tables (both with USERID field) in section access.

Thanks,