Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to create a section access using below data.
ACCESS | USERID | GROUP | OMIT |
USER | AGL\PK | TEAMQLIK | ManagementAmount |
USER | AGL\PK | TEAMQLIK | RAmount |
USER | AGL\PK | TEAMQLIK | PMAmount |
USER | AGL\PK | TEAMQLIK | GMAmount |
USER | AGL\PK | TEAMQLIK | Total Price |
Load script
-------------------
LOAD
"ACCESS",
"USERID",
"GROUP",
OMIT
FROM [lib://AN (agl_pk)/Access.xlsx]
(ooxml, embedded labels, table is Sheet1r);
But still i can see those fields in my app under My workspace.
Regards,
Prasanta
Do you have a Section Access; statement before the load and a Section Application; statement after?
yes, i have put the below script before my main load script for application.
LOAD
"ACCESS",
"USERID",
"GROUP",
OMIT
FROM [lib://AN (agl_pk)/Access.xlsx]
(ooxml, embedded labels, table is Sheet1r);
Hope it helps you
i am trying to implement this in qlik sense
also i have used the very similar kind of load script bu its not working.
LOAD
"ACCESS",
"USERID",
"GROUP",
OMIT
FROM [lib://AN (agl_pk)/Access.xlsx]
(ooxml, embedded labels, table is Sheet1r);