Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
rarora12
Contributor

Why a left join is needed with the section application and data

Hi,

I am trying to use security to limit the data the user can see per region + limit the tab the user can see

It doesn't work unless I do a left join to the section application

I can get the tab visibility to work but not both without the left join - as displayed below

Thanks in assisting me what I am missing

Rick

===========================

Section Access;

security:

LOAD * INLINE [

    ACCESS, NTNAME ,ROLE

    USER,BNDNA\ARORAR,A

];

Section Application; 

SheetAccess: 

 

LOAD * Inline [

ROLE,REGION,SH01,SH02,SH03,

A,SOUTH,0,0,1

A,WEST,0,0,1];

left join (SheetAccess)

regiondata:

LOAD * INLINE [

  

  REGION,  dpp_id, name, location

   SOUTH,  BAd111, badguy, MD

   NORTH,  BAd333, badguy22, MDVA

   WEST,  BAd222, badguy22, MDVA

];

2 Replies
Highlighted
kulwantsaj219
Contributor II

Re: Why a left join is needed with the section application and data

Section Access;

security:

LOAD * INLINE [

    ACCESS, NTNAME ,ROLE

    USER,BNDNA\ARORAR,A

];

Section Application;

SheetAccess:

LOAD * Inline [

ROLE,REGION,SH01,SH02,SH03,

A,SOUTH,0,0,1

A,WEST,0,0,1];

//left join (SheetAccess)

regiondata:

LOAD * INLINE [

 

  REGION,  dpp_id, name, location

   SOUTH,  BAd111, badguy, MD

   NORTH,  BAd333, badguy22, MDVA

   WEST,  BAd222, badguy22, MDVA

];

and put  condition on each sheet

for sheet id 3

SH03=1

Its working its showing only SH03 and for region its showing only south and west without left join

sec.PNGsec1.PNG

Highlighted
rarora12
Contributor

Re: Why a left join is needed with the section application and data

I don't get the same results - maybe i have the setting setup incorrectly.

Can i ask what is the difference in setting tab to =SH03 vs SH03=1

It just doesnt work for me

Thanks