Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
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.
Can you please tell me how do I find the wizard. Thanks!
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
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?
Jose,
Upper() function is necessary unlesss you use load inline.
Anyway, it's not clear what is "not working"...
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
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
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