Section Access On Multiple Tables with using Same field

[krishgk_ispot]

HI All,

I would like implement the Section Access on a Qliksense app.on a CustomerID field from dimension  table but restrict different CustomerID's from Order and Sales Tables.

Note: CUSTOMERID_ORDER and CUSTOMERID_SALES are alias of CustomerID field from Customer table.

section access;

load * inline [

ACCESS, USERID, CUSTOMERID_ORDER,CUSTOMERID_SALES, OMIT

USER, USER1, 1, 2,

USER, USER2, 2,<NONE>,

USER, USER3,<NONE>,3

];

Is it possible to restrict the data this way using single dimension filed on multiple fact tables differently?

If possible ,The fields from Orders table shouldn't be visible for User3. If possible hide whichever sheets uses fields from Orders table.

[Supriya4]

Hi,

Did you get a solution for this? I have the same problem.

Thanks !!