Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
priyarane
Specialist
Specialist

Section Access

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.

1 Solution

Accepted Solutions
Not applicable

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

View solution in original post

6 Replies
Not applicable

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

Not applicable

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

mukesh24
Partner - Creator III
Partner - Creator III

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

jagan
Luminary Alumni
Luminary Alumni

Hi Priya,

Check this links below

Sheet level access

Sheet Level Access

Hope it helps you.

Regards,

Jagan.

Not applicable

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"

its_anandrjs

Hi,

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

Regards

Anand