section access based on inline table

[arulsettu]

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

[Anonymous]

Hi,

Please find a sample qvf I have created for section access... also sample data I have used

thanks

[arulsettu]

access denied

[Anonymous]

that's may be because of the section access..

I am pasting the logic here . please follow the same order:

section access;
LOAD * inline [
ACCESS, USERID,CUSTOMER,SOCIETY
USER, OPD\F29121,100,10
USER, OPD\F29121,200,20
];

section application;
T1:
LOAD
    Key,
    Customer AS CUSTOMER,
    Society AS SOCIETY
FROM [lib://Temp (opd_f29121)/Calculated_value.xlsx]
(ooxml, embedded labels, table is Sheet2);

and the main fact data from excel is :

LOAD

    Key,

    Customer,

    Society,

    "Date 1",

    "Date 2",

    Value

FROM [lib://Temp (opd_f29121)/Calculated_value.xlsx]

(ooxml, embedded labels, table is Sheet2);

and what I see from the front end is data for Customer 100, 200 and Society 10,20 if you have a look at the source excel it has more data :

Thanks

Chandra

[reddy-s]

Hi Arul,

All the field names for section access in Qlik have to be in Capital letters. Give a try with capital letters for Field Names.

Thanks,

Sangram Reddy.

[arulsettu]

in section access everything in capital only right?

[arulsettu]

its executing but section access not working

[reddy-s]

Hi Arul,

That's right. Even the field linking to the section access table has to be uppercase.

Thanks,

sangram.

[arulsettu]

can you check this

section access;

load ACCESS, upper(USERID), Upper(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);

but nothing happening

[reddy-s]

Hi Arul,

The field names are still not in capital:

if you run your code, this what your section access table would look like:

as you can see they are not in capitals.

Try this instead:

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);

Thanks,

Sangram Reddy.