Hi Experts,
Can any one please help me on Data level security(Section access in qliksense) with Two fields coming from Two different tables.
Is this correct to apply data security on two fields from two tables? Please confirm.
The table structure is like below.Two tables are linked with ProductID field.
I have to apply section access on below two fields
Table1: Product Type/Segment
Table2: ProductDepartment
I have tried below code to implement. I will get the access on tomorrow to check this practically.
I am new to this topic. Please let me know am i missed any thing in below code.
Thanks in advance.
Section access source Excel structure
---------------------------------------------------------------------------------------------------
USERID ACCESS Product Type/Segment ProductDepartment
SERVICE\a12456 ADMIN * *
SERVICE\1hy567 USER T-Shirt Clothes
SERVICE\8ukjg5 USER Mobile Electronics
----------------------------------------------------------------------------------------------------------------------------------
Section access script
------------------------------------------------------------------------------------------------------------------------------------------
Section access;
Load
Upper(USERID) as USERID,
Upper(ACCESS) as ACCESS,
Upper([Product Type/Segment]) as [Product Type/Segment],
Upper([ProductDepartment]) as [ProductDepartment];
Section Application;
Table1:
Load
ProductID,
Upper([Product Type/Segment]) as [Product Type/Segment],
Sales
From
......
Table2:
Load
ProductID,
Upper([ProductDepartment]) as [ProductDepartment];
Trades
From
......
