Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

chandni90
New Contributor III

Section Access

Hi,

I want user A to not see the field 'MATERIAL' in the app. This is the source for my section access.

qlik.png

This is my section access code:

Section Access;

LOAD

    "ACCESS",

   upper( "USERID"),

    OMIT

FROM [lib://Access/test1.xlsx]

(ooxml, embedded labels, table is Sheet1);

Section Application;

Welcome:

LOAD

   

    Upper("USERID")as userid,

    NAME,

    OMIT

FROM [lib://Access)/test1.xlsx]

(ooxml, embedded labels, table is Sheet1);

However, the user is still able to see the field MATERIAL.qlik1.png

What am I doing wrrong?

4 Replies

Re: Section Access

Then don't make user A an Admin. Admin will see all the data. See this blog post: Tips and tricks for section access in Qlik Sense (2.0+)


talk is cheap, supply exceeds demand
chandni90
New Contributor III

Re: Section Access

User B is seeing the data.

Vegar
Valued Contributor

Re: Section Access

Try to change the row 

  upper( "USERID"),

into

  upper( "USERID") AS USERID,

MVP
MVP

Re: Section Access

Hi,

Try thsi

Section Access;

LOAD

    "ACCESS",

   upper( "USERID") AS USERID,

    OMIT

FROM [lib://Access/test1.xlsx]

(ooxml, embedded labels, table is Sheet1);

Section Application;

Welcome:

LOAD

  

    Upper("USERID")as USERID,

    NAME,

    OMIT

FROM [lib://Access)/test1.xlsx]

(ooxml, embedded labels, table is Sheet1);

Also check this link below.

Column level access using Section Access

Various levels of security implementation using Section Access

Regards,

Jagan.

Community Browser