topic Section Access in QlikView

Section Access

priyarane — Sun, 05 Apr 2015 19:09:26 GMT

Hi Experts,

How to give access for my below example.

Ex:

I have Two reports(SH01 and SH02) in qvw.

Users:

User1

User2

User3

User4

I wanted to give access like below

User1 - all reports(SH01 and SH02).

User2 and User3- first report(SH01).

User4 - second report(SH02)

How to achieve it? please help me.

Re: Section Access

Mon, 06 Apr 2015 05:50:00 GMT

Hi Priya,

In Hidden script

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, USERNAME

ADMIN, USER1, user1, USER1

USER, USER2, user2, USER2

USER, USER3, user3, USER3

];

Section Application;

SheetAccess:

LOAD * INLINE [

USERNAME, SHEET1FLAG, SHEET2FLAG

USER1, 1,1

USER2, 1,0

USER3, 0,1

];

Enable Condition in Sheet1 SHEET1FLAG=1 similarly for Sheet2

Re: Section Access

Mon, 06 Apr 2015 06:16:11 GMT

hi priya,

i will suggest you to give access as sheet level.

in object level you will face much problems.

you place two sheet-

in one sheet you put all object and in second put selected object.

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, USERNAME ,GROUP

ADMIN, USER1, user1, USER1 ,GROUP1

USER, USER2, user2, USER2 ,GROUP1

USER, USER3, user3, USER3,GROUP2

];

Section Application;

LOAD * INLINE [

GROUP,SH01, SH02

GROUP1, 1,1

GROUP2, 1,0

];

in sheet properties you use = sum(SH01)>=1

= sum(SH02)>=1

Regards

Vimlesh

Re: Section Access

mukesh24 — Mon, 06 Apr 2015 07:01:05 GMT

Hi,

Load following table in u r data model.

LOAD * INLINE [

QVUS, SHEET1, SHEET2

USER1, 1,1

USER2, 1,0

USER3, 1,0

USER3, 0,1

];

Use following expression in Sheet Properties --> General --> Conditional

only(if(QVUS=upper(OSUser()),SHEET1))>0

same condition for sheet2

only(if(QVUS=upper(OSUser()),SHEET2))>0

Regards,

Mukesh

Re: Section Access

jagan — Mon, 06 Apr 2015 07:14:42 GMT

Hi Priya,

Check this links below

Sheet level access

Sheet Level Access

Hope it helps you.

Regards,

Jagan.

Re: Section Access

Mon, 06 Apr 2015 07:27:38 GMT

hi priya,

try like this.......

ALL SHOULD BE IN CAPS ONLY WHILE GIVING SECTION ACCESS TO USER

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, USERNAME

ADMIN, USER1, USER1 , USER1

USER, USER2, USER2 , USER2

USER, USER3, USER3, USER3

USER, USER4, USER4, USER4

];

Section Application;

LOAD * INLINE [

USERNAME,SH01, SH02

USER1 , 1,1

USER2 , 1,0

USER3 , 1,0

USER4, 0,1

];

in 1st sheet properties write condition "=SH01" or "=SHEETNAME"

2nd sheet properties write condition "=SH02" or "=SHEETNAME"

Re: Section Access

its_anandrjs — Mon, 06 Apr 2015 07:32:31 GMT

Hi,

Go for Sheet level section access security, and implement the logic that way.

Regards

Anand