Qlik Community

QlikView Security & Governance

Discussion Board for collaboration on QlikView Security and Governance.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
Partner
Partner

Section Access On Multiple Tables with using Same field

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.