Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

pandunallani
Contributor II

omit section access?

If we would like to omit more than one column how could we do it? kindly help me on it?

6 Replies
lironbaram
Honored Contributor II

Re: omit section access?

hi

in order to omit omit more than one field,

you'll need one row for each field

you can do something like this, so you only insert one row per user

section access;

load ACCESS,

  USERID,

     SubField(OMIT,'|') AS OMIT;

LOAD * inline [

ACCESS, USERID, OMIT

USER, SENSE\ADMINISTRATOR,

USER, SENSE\LIRON,A|B

ADMIN, INTERNAL\SA_SCHEDULER,

];

Section Application;

pandunallani
Contributor II

Re: omit section access?

I tried what you said but its fail to take password, when you enter userid its opening application my scrip as follows check it plz.

Section Access;

load ACCESS,

  USERID,

  PASSWORD,

  %COUNTRY,

 

     SubField(OMIT,'|') AS OMIT;

LOAD * INLINE [

   

        ACCESS, USERID, PASSWORD, %COUNTRY,OMIT

   

    ADMIN, ADMIN1, ADMIN, *, *

    ADMIN, ADMIN2, ADMIN, IND,*

    USER, USER1, USER, AFG,Year

    USER, USER2, USER, BANGLA,Year|Customer

    user,user3, user,AUS,*

];

Section Application;

lironbaram
Honored Contributor II

Re: omit section access?

hi

if you use qlikview version 11.2

then instead of USERID rename the column to USER

pandunallani
Contributor II

Re: omit section access?

I used in qlikview 12 and it works but it hiding the two columns for all users, don't know why?

lironbaram
Honored Contributor II

Re: omit section access?

hi

run the load script

not as section access

and check the result you get

look if it add the columns to omit to all users

yakir_manor
New Contributor III

Re: omit section access?

you can read in this link:

http://www.qliktips.com/2011/04/blocking-user-access-to-field-using.html

the problem in the link is that they didn't use upper case,

but basically create a mapping table like so

Section Access;

LOAD * INLINE [

ACCESS, USERID, OMITGROUP

USER, USER1, OG1

USER, USER2, OG2

];

LOAD * INLINE [

OMITGROUP, OMIT

OG1, Field1

OG1, Field2

OG1, Field3

OG2, Field4

];

Section Application;

Community Browser