Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi,
Please find a sample qvf I have created for section access... also sample data I have used
thanks
access denied
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
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.
in section access everything in capital only right?
its executing but section access not working
Hi Arul,
That's right. Even the field linking to the section access table has to be uppercase.
Thanks,
sangram.
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
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.