topic Section Access Based on Two Fields in QlikView

Section Access Based on Two Fields

Thu, 17 May 2012 17:45:11 GMT

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!

Section Access Based on Two Fields

chematos — Thu, 17 May 2012 19:53:23 GMT

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.

Section Access Based on Two Fields

Thu, 17 May 2012 20:04:54 GMT

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

Section Access Based on Two Fields

chematos — Thu, 17 May 2012 20:17:14 GMT

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

Section Access Based on Two Fields

garystrader — Thu, 17 May 2012 22:30:15 GMT

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?

Section Access Based on Two Fields

Anonymous — Fri, 18 May 2012 01:08:55 GMT

Jose,

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

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

Section Access Based on Two Fields

Fri, 18 May 2012 03:41:28 GMT

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

Re: Section Access Based on Two Fields

subin6600 — Fri, 18 May 2012 06:28:37 GMT

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.

BR/Subin

Re: Section Access Based on Two Fields

Thu, 25 Oct 2012 07:53:33 GMT

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