Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
bohravanraj
Partner
Partner

Section Access Requirement

Hi Guys,

I have a data is at user Level as Below

UserRegionCityTeam

.

and want to implement a Section Access for User.

Here Client will fill Excel as below

UserAccess
USER AALL
USER BUSER
USER CREGION
USER DCITY
USER E

TEAM

Here it should work like

For User A : All Access

For User B : it should only have his user Access
For User C : He Should have all the Access of his Region irrespective of User.(All User of his Region).

For User D : He Should have all the Access of his City irrespective of User.(All User of his City).

For User E : He Should have all the Access of his Team irrespective of User.(All User of his Team).


any help is appreciated.


Thanks.

2 Replies
Not applicable

Hi Vanraj,

This may help you.

https://community.qlik.com/docs/DOC-1853

-Ashok.

hemanthaanichet
Creator III
Creator III

Hi Vanraj,

Try this:


Section Access;

SECURITY:

LOAD * INLINE [
ACCESS, USERID, OMIT, USERNAME

ADMIN, USERA, , USERB

USER, USERB, , USERB
USER, USERC, CITY, USERB

USER, USERC, TEAM, USERB

USER, USERD, REGION, USERB

USER, USERD, TEAM, USERB

USER, USERE, REGION, USERB

USER, USERE,  CITY, USERB

];

Section Application;

ACCESSSECURITY:

LOAD * INLINE [

USERNAME, USERID, PASSWORD

USERB, USERA, ABCD

USERB, USERB, EFGH

USERB, USERC, IJKL

USERB, USERD, MNOP

USERB, USERE, QRST

];




Regards

Hemanth