Section access Issue

[#1]

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

[jonathandienst]

Do you have a Section Access; statement before the load and a Section Application; statement after?

[#3]

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

[sunilkumarqv]

Hope it helps you

Introduction to Section Access

[#5]

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