Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator 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
Highlighted
Partner
Partner

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;

Highlighted
Creator II
Creator II

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;

Highlighted
Partner
Partner

hi

if you use qlikview version 11.2

then instead of USERID rename the column to USER

Highlighted
Creator II
Creator II

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

Highlighted
Partner
Partner

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

Highlighted
Contributor III
Contributor III

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;