Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mahitham
Contributor

section access with two fields

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

......


1 Reply
praveenkumar_ma
Contributor

Re: section access with two fields

Hi Mahitha,

i have done somethingf like this

Section access source Excel structure

---------------------------------------------------------------------------------------------------

USERID                      ACCESS                   ProductDepartment                ProductType/Segment

SERVICE\a12456                ADMIN                                               *                                                                  *

SERVICE\1hy567                USER                               Cloths                                                             T-Shirts       

SERVICE\8ukjg5                 USER                                Electronics                                                      Mobile       

----------------------------------------------------------------------------------------------------------------------------------

Section access script

------------------------------------------------------------------------------------------------------------------------------------------


I think this is how it should be , remaining is correct i guess .



Thanks

PM

Community Browser