Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Section Access Based on Two Fields

Is it possible to impliment section access based on two fields? I tried code below but its not working:

Section ACCESS;

LOAD

UPPER([ACCESS]) as ACCESS,

UPPER(ACCESS_KEY) as ACCESS_KEY,

UPPER(ACCESS_KEY_1) as ACCESS_KEY_1,

UPPER (NTNAME) as NTNAME

FROM ..\Data\IS_HR_Access.xlsx (ooxml, embedded labels, table is Sheet1);

section application;

star is *;

Any suggestions? I appreciate your time. Thanks!

1 Solution

Accepted Solutions
subin6600
Creator III
Creator III

I Guess the below syntax would help you.

section Access;
STAR is *;

User:
LOAD * INLINE [
    ACCESS, NTNAME, REGION
    ADMIN, ABC, ,
// user whoneeds to have admin access

    ADMIN, BCD, , // user who needsto have admin access

    ADMIN, CDE, , // user who needs to have adminaccess

    ADMIN, DEF, , // user who needs to have adminaccess


          ]
;

concatenate ([User])
LOAD
     'USER'
as [ACCESS]
    
upper(trim([User ID])) as [NTNAME],
    
If(isnull(trim([REGION])) = 0, Upper([REGION]), ' ') as [REGION]
     FROM
[<Pathname>test.xlsx]
(
ooxml, embedded labels, table is Authorization);

Section Application;
Set Application_Name       = ABC Report';
Set Developer_Contact      = 'abc';

Set Cargotec_Contact    = 'abc';

Set Mail                     = 'abc@abc.com;

Set Phone                    = '+12345’;

Set ShortDescription ='xyz;

Note*: Please remember to select the option in Settings> Document Settings> check Initial Data reduction based on section access.

nogap.JPG

BR/Subin

View solution in original post

8 Replies
chematos
Specialist II
Specialist II

Hi,

Have you seen the section access wizard in your QlikView?? You could use the inline sentence with the fields you choose and if you prefer, do the same in an excel sheet.

I think the UPPER function is not necessary. 

Not applicable
Author

Can you please tell me how do I find the wizard. Thanks!

chematos
Specialist II
Specialist II

In the script menu you have the menu Insert, and there is an option on that menu that says Section Access > and in there is an Inline option. Tell me of you find it

garystrader
Partner - Creator III
Partner - Creator III

It's possible to do section access with two or more reduction fields.  You should make sure single field reduction is working first before you tackle multiple field reduction.  What exactly is not working?

Anonymous
Not applicable
Author

Jose,

Upper() function is necessary unlesss you use load inline.

Anyway, it's  not clear what is "not working"...

Not applicable
Author

Hi Siddharth,

It is possible to have section access on multiple fileds. Please upload a sample application so that I can do and report it again.

BR,

Veman Reddy

subin6600
Creator III
Creator III

I Guess the below syntax would help you.

section Access;
STAR is *;

User:
LOAD * INLINE [
    ACCESS, NTNAME, REGION
    ADMIN, ABC, ,
// user whoneeds to have admin access

    ADMIN, BCD, , // user who needsto have admin access

    ADMIN, CDE, , // user who needs to have adminaccess

    ADMIN, DEF, , // user who needs to have adminaccess


          ]
;

concatenate ([User])
LOAD
     'USER'
as [ACCESS]
    
upper(trim([User ID])) as [NTNAME],
    
If(isnull(trim([REGION])) = 0, Upper([REGION]), ' ') as [REGION]
     FROM
[<Pathname>test.xlsx]
(
ooxml, embedded labels, table is Authorization);

Section Application;
Set Application_Name       = ABC Report';
Set Developer_Contact      = 'abc';

Set Cargotec_Contact    = 'abc';

Set Mail                     = 'abc@abc.com;

Set Phone                    = '+12345’;

Set ShortDescription ='xyz;

Note*: Please remember to select the option in Settings> Document Settings> check Initial Data reduction based on section access.

nogap.JPG

BR/Subin

Not applicable
Author

Hi All,

I have the same question: how can I split the access by several fields (for ex. REGION and CLIENT). Here (in Correct Answer) I see access split by REGION field only (one field). What is the way to make access to different users by different (several) fields?

For ex. I have to following table of regions/clients:

Region     Client

AAA     AAA1

AAA     AAA2

BBB     BBB1

BBB     BBB2

BBB     BBB3

CCC     CCC1

CCC     CCC2

CCC     CCC3

CCC     CCC4

And I need to give the following access (for managers - on region level and for specialists - on client level):

User     Region     Client

ManagerA     AAA     *

SpecialistA1     AAA     AAA1

SpecialistA2     AAA     AAA2

ManagerB     BBB     *

SpecialistB1     BBB     BBB1

SpecialistB2     BBB     BBB2

SpecialistB3     BBB     BBB3

ManagerC     CCC     *

SpecialistC1     CCC     CCC1

SpecialistC2     CCC     CCC2

SpecialistC3     CCC     CCC3

SpecialistC4     CCC     CCC4

Thanks for your help.

Regards,

Roman.

PS The table below is working (:)) but the need is not to copy each specialist's line to according manager but grant managers' access by region which includes according clients.

User     Client

ManagerA     AAA1

ManagerA     AAA2

SpecialistA1     AAA1

SpecialistA2     AAA2

ManagerB     BBB1

ManagerB     BBB2

ManagerB     BBB3

SpecialistB1     BBB1

SpecialistB2     BBB2

SpecialistB3     BBB3

ManagerC     CCC1

ManagerC     CCC2

ManagerC     CCC3

ManagerC     CCC4

SpecialistC1     CCC1

SpecialistC2     CCC2

SpecialistC3     CCC3

SpecialistC4     CCC4

Message was edited by: romanergakov