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: 
arulsettu
Master III
Master III

section access based on inline table

i am having field like this

company_code,company

1,company1

2,company2

3,company3

4,company4

now i want to create a group. that means all the companies

for that i created a inline table

LOAD * Inline [

company_code,company

1,company1

2,company2

3,company3

4,company4

1,group

2,group

3,group

4,group

];

now i used this company in section access

section access;

load ACCESS, USERID, Upper(Company) inline [

ACCESS, USERID, Company

USER, DOMAIN\arul.settu, Group

];

Section Application;

it is not working. can any one tell me how can i achieve this

Thanks

sangram reddy

18 Replies
arulsettu
Master III
Master III
Author

section access;

load ACCESS, upper(USERID) as USERID, Upper(COMPANY) as COMPANY inline [

ACCESS, USERID, COMPANY

USER, DOMAIN\arul.settu, Group

];

Section Application;

LOAD _COMP_CODE,

     CurrNo,

     upper(Company) as COMPANY,

     Currency

FROM

(ooxml, embedded labels, table is Sheet1);

nothing happened still can see all the companies

Anonymous
Not applicable

Hi,

this worked for me:

section access;
LOAD * inline [
ACCESS, USERID,COMPANY
USER, OPD\F29121,GROUP

];

section application;
T1:

LOAD
    Company_Code,
    UPPER(Company) AS COMPANY
FROM [lib://Temp (opd_f29121)/Sec_test.xlsx]
(ooxml, embedded labels, table is Sheet2);

Thanks

Anonymous
Not applicable

screen shot and the excel attached:

reddy-s
Master II
Master II

Hi Arul,

If you want to give access to all the companies then try "*" instead of the "group"

section access;

load ACCESS, upper(USERID), Upper(COMPANY) inline [

ACCESS, USERID, COMPANY

USER, DOMAIN\arul.settu, *

];

arulsettu
Master III
Master III
Author

actually i need to show a filter like this

company1

company2

company3

company4

group


one user will see company1

one user will see all company and group as well


so group is mandatory here

Anonymous
Not applicable

I have used the same data:

Thanks

arulsettu
Master III
Master III
Author

Thanks both of you....

arulsettu
Master III
Master III
Author

sangram reddy 

one doubt if company like this 

001-company1

we nee to give this in section acces with single quotes

'001-company1'   ?????

thanks

reddy-s
Master II
Master II

Hi Arul,

No you dont have to. Just convert it to uppercase

Thanks,

Sangram.