Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

4 Replies
sinanozdemir
Specialist III
Specialist III

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

Anonymous
Not applicable
Author

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,

aniketsr
Creator
Creator

Hi,

did you happen to get some work around on this?

Othman_malouane
Contributor
Contributor

Hello ,

Did you find a solution to this issue please ?

Thanks in advance .