Qlikview section access for cross country access(all the team member with belong to same team can access each other data)

[priyanka08]

Hi  All,

I want to implement section access like all the team member with belong to same  team can access each other data as they are sharing same boss

For example shikha belong to India and avani belongs to  TW  but both sharing same boss  . So once shikha login she can see gcin tagged to  avani along with  all other who are reporting to gyan

[a_mullick]

Hi,

Something like this should work (I've user INLINE LOAD just as an example, but you can load the data from any data-source) :

Set up the access table linking users to their team leads, makng sure to link a team lead to themself (NTNAME needs to conform to your standard):

SECTIONAccess;
ACCESS01:
LOAD * INLINE [

ACCESS, NTNAME, SCOPE
USER, SHIKHA, GYAN
USER, AVANI, GYAN
USER, PALLAVI, GYAN
USER, PRIYA, GYAN
USER, AJIT, SUDHIR
USER, SUDHIR, SUDHIR
USER, GYAN, GYAN];

Then somewhere in 'SECTION Application' add a table like this:

[Access Scope]:

LOAD * INLINE [

GCIN, SCOPE
GC001, GYAN
GC002, GYAN
GC003, GYAN
GC004, GYAN
GC005, GYAN
GC006, GYAN
GC007, GYAN
GC008, GYAN
GC009, GYAN
GC010, SUDHIR
GC011, SUDHIR
GC012, SUDHIR
GC013, SUDHIR
GC014, SUDHIR
GC015, SUDHIR
GC016, SUDHIR];

I'm assuming that GCIN will join to your other tables, so now the individual users will see the same as the team leaders.