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.
