Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

arulsettu
Honored Contributor 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

1 Solution

Accepted Solutions
gompa786
Contributor III

Re: section access based on inline table

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

View solution in original post

18 Replies
gompa786
Contributor III

Re: section access based on inline table

Hi,

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

thanks

arulsettu
Honored Contributor III

Re: section access based on inline table

access denied

Highlighted
gompa786
Contributor III

Re: section access based on inline table

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

reddys310
Honored Contributor II

Re: section access based on inline table

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
Honored Contributor III

Re: section access based on inline table

in section access everything in capital only right?

arulsettu
Honored Contributor III

Re: section access based on inline table

its executing but section access not working

reddys310
Honored Contributor II

Re: section access based on inline table

Hi Arul,

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

Thanks,

sangram.

arulsettu
Honored Contributor III

Re: section access based on inline table

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

reddys310
Honored Contributor II

Re: section access based on inline table

Hi Arul,

The field names are still not in capital:

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

Capture.PNG

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

Capture1.PNG

Thanks,

Sangram Reddy.